"Import succeded with warnings" and ERRORS!?

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 20 Oct 2001 02:33:42 +0200
Message-ID: <qih1ttoslto2v8p9qd5tnto8m2vffek6j9_at_4ax.com>

Hello

I got a full dump file from another company and imported it into our development DB (8.1.7, Solaris). I did this my first time and it did not work at my first try since the objects in the target DB are populated, and we need an exact copy of the DB which produced the dump file. Just using IGNORE=Y is not enough for our needs. The dump corresponds to a newer, more experimental version of the DB than the one contained at the target.

I could have created a new, empty instance but the tablespaces are needed too because otherwise the import will fail if the paths of the DB files differ (they probably do). So I dropped cascade all users but SYS and SYSTEM in the target DB and did the import. But I got hundreds of errors along a final notice that "the import succeded with warnings". Now I am quite confused.

First of all, I was warned that the exporting and importing user do not match (I imported as user / as sysdba).

Then lots of errors occured because users MDSYS and CTXSYS weren't found. Well, I thought there were supposed to be created!!

It seems that constraints are violated, views or roles or users do not exists (weren't they supposed to be created?). Perhaps I should have dropped the SYSTEM user too, not sure.

I never thought that achieving the right conditions for an import would be so hard. Of course, I could have created the tablespaces on a new instance, but how the hell I know which tablespaces are going to be needed, and how they were created in the originating DB?

What is the standard procedure in order to import a dump file when the paths of the datafiles on the origin and on the target differ? (Because if they didn't, I could use a clean instance).

See more errors below (exerpts):

Import SYS's Objects in SYS
IMP-00017: Following commands did not succeed because Oracle error 4042
"BEGIN "
"SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON
DBMS_DEFER_QUERY TO DBA');"
"COMMIT; END;"

IMP-00003: Oracle error 4042 found
ORA-04042: Procedure, function, package or ... does not exist
"SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON DBMS_REPCAT TO
SYSTEM"

ORA-06512: in "SYS.DBMS_SYS_SQL", line 824
ORA-06512: in "SYS.DBMS_SQL", line 32
ORA-06512: in "SYS.DBMS_UTILITY", line 409

"SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON
DBMS_INTERNAL_REPCAT TO EXECUTE_CATALOG_ROLE');"
"SYS.DBMS_UTILITY.EXEC_DDL_STATEMENT('GRANT EXECUTE ON
DBMS_RECTIFIER_DIFF TO EXECUTE_CATALOG_ROLE');" PLS-00302: Component 'QUEUE_IMPORT_CHECK' must be declared Oracle Error 6550 "BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('METATEST.US.ORAC"
"LE.COM','IBMPC/WIN_NT-8.1.0'); END;"

IMP-00019: line rejected  because Oracle Error 1
IMP-00003: Oracle Error 1 found
ORA-00001: Violation of uniqueness rule (SYSTEM.HELP_TOPIC_SEQ)
IMP-00019: line rejected  because Oracle Error 1
IMP-00003: Oracle Error 1 found
ORA-00001: Violation of uniqueness rule (SYSTEM.PBSYSPBE_IDX)

... rule SYSTEM.PBSYSCATFRMTS_IDX)
... rule (SYSTEM.REPCAT$_AUDIT_ATTRIBUTE_PK) Object compiled with warnings...
IMP-00017: Following command failed due to Oracle Error 942:
"GRANT DELETE ON "ALIQUOT_VIEW" TO "PIMS_USER""
IMP-00003: Oracle Error 942 found
ORA-00942: Table or view does not exist

Thanks a lot in advance

Rick Received on Sat Oct 20 2001 - 02:33:42 CEST