Erro
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[oracle@bdora bkp_logico]$ time impdp system/password schemas=ORCL directory=BKPDIR dumpfile=bkp2509.dmp logfile=imp2509.log EXCLUDE=STATISTICS Import: Release 12.2.0.1.0 - Production on Thu Sep 27 16:28:19 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production ORA-39002: invalid operation ORA-39168: Object path STATISTICS was not found. real 0m22.293s user 0m0.037s sys 0m0.041s |
Causa
|
1 |
Iniciando "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" directory=BKPDIR dumpfile=bkp2509.dmp logfile=bkp2509.log exclude=statistics full=y reuse_dumpfiles=y |
Analisando o export foi utilizado o parâmetro EXCLUDE=STATISTICS
Solução
Removido o parâmetro EXCLUDE=STATISTICS da rotina de import.
Import realizado com sucesso.