Oracle Database Discussions

i export the full database as a dump file in one location after that i tried to import to another database.
my doubt is if i import the database ....the existing database is having datadictionary ,v$views etc..
so wont it clash with the existing systemtables
When i import my database i got the followin error

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','SYS',TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','DBA',TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','IMP_FULL_DATABASE',FALS"
"E);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','AQ_ADMINISTRATOR_ROLE',"
"TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','OEM_MONITOR',FALSE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('DEQUEUE_ANY','SYS',TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('DEQUEUE_ANY','DBA',TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('DEQUEUE_ANY','AQ_ADMINISTRATOR_ROLE'"
",TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('ENQUEUE_ANY','SYS',TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('ENQUEUE_ANY','DBA',TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('ENQUEUE_ANY','AQ_ADMINISTRATOR_ROLE'"
",TRUE);"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYS"
ORA-06512: at "SYS.DBMS_AQADM", line 480
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "REPCAT$_OBJECT_NULL_VECTOR" TIMESTAMP '2005-08-30:14:05:35' OI"
"D '296EAC6057114D26B123A36D2679C516' AS OBJECT"
"("
" -- type owner, name, hashcode for the type represented by null_vector"
" type_owner VARCHAR2(30),"
" type_name VARCHAR2(30),"
" type_hashcode RAW(17),"
" -- null_vector for a particular object instance"
" -- ROBJ REVISIT: should only contain the null image, and not version#"
" null_vector RAW(2000)"
")"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>NULL, export_db_name=>'"
"ORCLBK.REGRESS.RDBMS.DEV.US.ORACLE.COM', inst_scn=>'820250');sys.dbms_logre"
"p_imp.bump_scn(scn=>'820250');"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_IMP", line 274
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_REPCAT_MIG.PRE_IMPORT;"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_MIG_INTERNAL"
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 116
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',d"
"bms_server_alert.operator_NONE,'',1,3,'orclbk',dbms_server_alert.object_typ"
"e_SYSTEM,'');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 93:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(2018,dbms_server_alert.operator_GE,'100',db"
"ms_server_alert.operator_NONE,'',1,2,'orclbk',dbms_server_alert.object_type"
"_SYSTEM,'');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 92:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Administrative');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Application');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Concurrency');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Configuration');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Network');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'10',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Other');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Cluster');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1000,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Commit');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Administrative');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Application');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Concurrency');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Configuration');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Network');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'30',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Other');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'50',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Cluster');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"dbms_server_alert.set_threshold(1001,dbms_server_alert.operator_GT,'50',dbm"
"s_server_alert.operator_NONE,'',1,1,'orclbk',dbms_server_alert.object_type_"
"EVENT_CLASS,'Commit');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 91:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 29371:
"BEGIN "
"dbms_resource_manager.set_consumer_group_mapping_pri(1,7,6,9,8,10,5,4,3,2);"
"dbms_resource_manager.set_consumer_group_mapping('ORACLE_USER','SYSTEM','SY"
"S_GROUP');"
"dbms_resource_manager.set_consumer_group_mapping('ORACLE_USER','SYS','SYS_G"
"ROUP');"
"dbms_resource_manager.submit_pending_area;"
"COMMIT; END;"
IMP-00003: ORACLE error 29371 encountered
ORA-29371: pending area is not active
ORA-06512: at "SYS.DBMS_RMIN", line 332
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 413
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','"
"CURRENT_SCHEMA'), export_db_name=>'ORCLBK.REGRESS.RDBMS.DEV.US.ORACLE.COM',"
" inst_scn=>'820288');"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_LOGREP_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_UTIL"
ORA-06512: at "SYS.DBMS_LOGREP_IMP", line 274
ORA-06512: at line 2
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCLBK.REGRESS.R"
"DBMS.DEV.US.ORACLE.COM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_AQCALL" 0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCLBK.REGRESS.R"
"DBMS.DEV.US.ORACLE.COM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_AQERROR" 0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCLBK.REGRESS.R"
"DBMS.DEV.US.ORACLE.COM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_CALLDEST" 0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCLBK.REGRESS.R"
"DBMS.DEV.US.ORACLE.COM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_DEFAULTDEST" 0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCLBK.REGRESS.R"
"DBMS.DEV.US.ORACLE.COM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_DESTINATION" 0 rows imported
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('ORCLBK.REGRESS.R"
"DBMS.DEV.US.ORACLE.COM','IBMPC/WIN_NT-8.1.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 9:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_ERROR" 0 rows imported
. . importing table "DEF$_LOB" 0 rows imported
. . importing table "DEF$_ORIGIN" 0 rows imported
. . importing table "DEF$_PROPAGATOR" 0 rows imported
. . importing table "DEF$_PUSHED_TRANSACTIONS" 0 rows imported
. . importing table "DEF$_TEMP$LOB" 0 rows imported
. . importing table "DEPT" 0 rows imported
. . importing table "DEPT1" 0 rows imported
. . importing table "EMP" 0 rows imported
. . importing table "EMP1" 0 rows imported
. . importing table "LOGSTDBY$APPLY_MILESTONE" 0 rows imported
. . importing partition "LOGSTDBY$APPLY_PROGRESS":"P0" 0 rows imported
. . importing table "LOGSTDBY$EVENTS" 0 rows imported
. . importing table "LOGSTDBY$HISTORY" 0 rows imported
. . importing table "LOGSTDBY$PARAMETERS" 0 rows imported
. . importing table "LOGSTDBY$PLSQL" 0 rows imported
. . importing table "LOGSTDBY$SCN" 0 rows imported
. . importing table "LOGSTDBY$SKIP" 0 rows imported
. . importing table "LOGSTDBY$SKIP_TRANSACTION" 0 rows imported
. . importing table "MVIEW$_ADV_INDEX" 0 rows imported
. . importing table "MVIEW$_ADV_PARTITION" 0 rows imported
. . importing table "REPCAT$_AUDIT_ATTRIBUTE" 2 rows imported
. . importing table "REPCAT$_AUDIT_COLUMN" 0 rows imported
. . importing table "REPCAT$_COLUMN_GROUP" 0 rows imported
. . importing table "REPCAT$_CONFLICT" 0 rows imported
. . importing table "REPCAT$_DDL" 0 rows imported
. . importing table "REPCAT$_EXCEPTIONS" 0 rows imported
. . importing table "REPCAT$_EXTENSION" 0 rows imported
. . importing table "REPCAT$_FLAVORS" 0 rows imported
. . importing table "REPCAT$_FLAVOR_OBJECTS" 0 rows imported
. . importing table "REPCAT$_GENERATED" 0 rows imported
. . importing table "REPCAT$_GROUPED_COLUMN" 0 rows imported
. . importing table "REPCAT$_INSTANTIATION_DDL" 0 rows imported
. . importing table "REPCAT$_KEY_COLUMNS" 0 rows imported
. . importing table "REPCAT$_OBJECT_PARMS" 0 rows imported
. . importing table "REPCAT$_OBJECT_TYPES" 28 rows imported
. . importing table "REPCAT$_PARAMETER_COLUMN" 0 rows imported
. . importing table "REPCAT$_PRIORITY" 0 rows imported
. . importing table "REPCAT$_PRIORITY_GROUP" 0 rows imported
. . importing table "REPCAT$_REFRESH_TEMPLATES" 0 rows imported
. . importing table "REPCAT$_REPCAT" 0 rows imported
. . importing table "REPCAT$_REPCATLOG" 0 rows imported
. . importing table "REPCAT$_REPCOLUMN" 0 rows imported
. . importing table "REPCAT$_REPGROUP_PRIVS" 0 rows imported
. . importing table "REPCAT$_REPOBJECT" 0 rows imported
. . importing table "REPCAT$_REPPROP" 0 rows imported
. . importing table "REPCAT$_REPSCHEMA" 0 rows imported
. . importing table "REPCAT$_RESOLUTION" 0 rows imported
. . importing table "REPCAT$_RESOLUTION_METHOD" 19 rows imported
. . importing table "REPCAT$_RESOLUTION_STATISTICS" 0 rows imported
. . importing table "REPCAT$_RESOL_STATS_CONTROL" 0 rows imported
. . importing table "REPCAT$_RUNTIME_PARMS" 0 rows imported
. . importing table "REPCAT$_SITES_NEW" 0 rows imported
. . importing table "REPCAT$_SITE_OBJECTS" 0 rows imported
. . importing table "REPCAT$_SNAPGROUP" 0 rows imported
. . importing table "REPCAT$_TEMPLATE_OBJECTS" 0 rows imported
. . importing table "REPCAT$_TEMPLATE_PARMS" 0 rows imported
. . importing table "REPCAT$_TEMPLATE_REFGROUPS" 0 rows imported
. . importing table "REPCAT$_TEMPLATE_SITES" 0 rows imported
. . importing table "REPCAT$_TEMPLATE_STATUS" 3 rows imported
. . importing table "REPCAT$_TEMPLATE_TARGETS" 0 rows imported
. . importing table "REPCAT$_TEMPLATE_TYPES" 2 rows imported
. . importing table "REPCAT$_USER_AUTHORIZATIONS" 0 rows imported
. . importing table "REPCAT$_USER_PARM_VALUES" 0 rows imported
. . importing table "SQLPLUS_PRODUCT_PROFILE" 0 rows imported
IMP-00041: Warning: object created with compilation warnings

"CREATE FORCE VIEW "ORCLBKP2"."MVIEW_EVALUATIONS" ("R"
"UNID","MVIEW_OWNER","MVIEW_NAME","RANK","STORAGE_IN_BYTES","FREQUENCY","CUM"
"ULATIVE_BENEFIT","BENEFIT_TO_COST_RATIO") AS "
"select"
" t1.runid# as runid,"
" summary_owner AS mview_owner,"
" summary_name AS mview_name,"
" rank# as rank,"
" storage_in_bytes,"
" frequency,"
" cumulative_benefit,"
" benefit_to_cost_ratio"
"from SYSTEM.MVIEW$_ADV_OUTPUT t1, SYSTEM.MVIEW$_ADV_LOG t2, ALL_USERS u"
"where"
" t1.runid# = t2.runid# and"
" u.username = t2.uname and"
" u.user_id = userenv('SCHEMAID') and"
" t1.output_type = 1"
"order by t1.rank#"

IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_TABLE_DEFN_UPDATE('SYSTEM','DEF$_AQC"
"ALL',2,16384,2,0,0,'', '-07:00'); END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_IMPORT_INTERNAL"
ORA-06512: at line 1
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_IMPORT_INTERNAL"
ORA-06512: at line 1
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_IMPORT_INTERNAL"
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_TABLE_DEFN_UPDATE('SYSTEM','DEF$_AQE"
"RROR',2,16384,2,0,0,'', '-07:00'); END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_IMPORT_INTERNAL"
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE(HEXTORAW('388C27256DB141"
"49A4087915FDBE8A95'),'SYSTEM','DEF$_AQERROR','DEF$_AQERROR',0,5,0,1,0,'Erro"
"r Queue for Deferred RPCs'); END;"
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_DEFN_UPDATE(HEXTORAW('E5BCDC95348B40"
"C68F1295D72049BBAA'),'SYSTEM','DEF$_AQERROR','AQ$_DEF$_AQERROR_E',1,0,0,0,0"
",'exception queue'); END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQ_IMPORT_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_IMPORT_INTERNAL"
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN SYS.DBMS_REPCAT.REPCAT_IMPORT_REPSCHEMA; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_REPCAT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT"
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 4063:
"BEGIN "
"SYS.DBMS_AQ_IMP_INTERNAL.CLEANUP_SCHEMA_IMPORT;"
"COMMIT; END;"
IMP-00003: ORACLE error 4063 encountered
ORA-04063: package body "SYS.DBMS_AQ_SYS_IMP_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQ_SYS_IMP_INTERNAL"
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 191
ORA-06512: at line 2
Import terminated successfully with warnings.