Re: "Import succeded with warnings" and ERRORS!?

You can easily get a "dump" of what the import file contains by specifying indexfile=<filename> on the imp command line. The indexfile you specify will contain the sql statements that imp would run if you had just imported the file. Specifying indexfile causes the file to not be imported.

The source database has the packages for replication (the repcat messages you received) plus others given the existence of MDSYS and CTXSYS.

Did you specify full=y?

I would not recommed dropping the system user.

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:8tb1ttoqj477n56pfmembms29555t71kvi_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 Fri Oct 19 2001 - 21:36:34 CDT