Database Software

I have performed a full 10g database export (expdp full=y …)

I then created a new database 11g db and tried importing the full db using impdp ( full=y user=system/*** ) … I normally do schema export but this time I have so many schemas and thought it would be quicker if i do full export...


the imprort has succeeded, but it has also generated 2,500 errors ( ORA- errors!!) some sample erros are below … mainly object exists type erros ..

ORA-31684: Object type SYNONYM:"SYSTEM"."TABQUOTAS" already exists
ORA-31684: Object type TYPE:"SYSMAN"."SMP_EMD_LSNR_GEN_STATUS_OBJ" already exists
ORA-39151: Table "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_H" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "SYSTEM"."DEF$_DEFAULTDEST" exists. All dependent metadata and data will be skipped due to table_exists_action of skip
ORA-39151: Table "OLAPSYS"."CWM$ITEMUSE" exists. All dependent metadata and data will be skipped due to table_exists_action of skip

OA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "OE"."LINEITEM_TABLE_MEMBERS" does not exist or insufficient privileges
Failing sql is:
DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); c DBMS_METADATA.T_VAR_COLL; df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS'; BEGIN DELETE FROM "SYS"."IMPDP_STATS"; i_n := 'LINEITEM_TABLE_MEMBERS'; i_o := 'OE'; INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES ('I'
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-20000: INDEX "OE"."ACTION_TABLE_MEMBERS" does not exist or insufficient privileges
ORA-39111: Dependent object type OBJECT_GRANT:"OLAPSYS" skipped, base object type PACKAGE:"OLAPSYS"."CWM2_OLAP_DIMENSION_ATTRIBUTE" already exists


Just out of curiosity why does oracle ( impdp ) is trying to import or modify system and other default schemas? Is there any point in modifying or attempting to re-import those schemas? in particular sys and system…

Am I correct saying I should ignore those errors?

I also have some of below erros …

ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (abc.FK_customer) - parent keys not found

I know for sure the db wasn’t in use when I performed the exp ( so the export must be consistent) what could be other cause of this?

thanks

Brian