IMPort Oracle

Case:

-created a new schema without data and need to import data into it from a dump

IMP userid=system/manager@DB file=D:\Full-SP4.dmp fromuser=LADORNA touser=COPIE ignore=Y grants=N buffer=4096000 log=D:\Import_COPIE.log
I get the following errors even if import goes ok.

IMP-00017: following statement failed with ORACLE error 20005:
“BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,’”ACS_ACCOUNTING_U1″‘,NULL,NULL,NULL”
“,3,1,3,1,1,1,0,6); END;”
IMP-00003: ORACLE error 20005 encountered
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at “SYS.DBMS_STATS”, line 1607
ORA-06512: at “SYS.DBMS_STATS”, line 2117
ORA-06512: at “SYS.DBMS_STATS”, line 5394
ORA-06512: at line 1

Merge si asa dar o tabela nu s-a imprtat. Am rulat din nou si a mers. E posibil s fie de la ordinea de import. Fac test acum cu import pe Constraint=N si apoi Constraint = Y.

Ramane de verificat si daca e de la export sa se fi facut without CONSISTENT=Y

import into your new database with rows=y constraints=n ignore=y
import from same export file rows=n contraints=y