RE: export/import errors

You have packages with status INVALID.
Correct them and the errors will go away. Been there.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Farnsworth, Dave [SMTP:DFarnsworth_at_Ashleyfurniture.com]
> Sent: Thu, February 07, 2002 5:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export/import errors
>
> I just did my first export/import and of course I got some errors at the
> very end of my import log file. My problem is I don't have a clue as to
> what they are. Below is the last few lines of the import log file
>
> About to enable constraints...
> . importing DIS's objects into DIS
> . importing DRV's objects into DRV
> . importing EDI's objects into EDI
> . importing FINANCE's objects into FINANCE
> . importing CIM's objects into CIM
> . importing DIS's objects into DIS
> . importing DRV's objects into DRV
> . importing EDI's objects into EDI
> IMP-00017: following statement failed with ORACLE error 4068:
> "BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END;"
> IMP-00003: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_REPCAT_SNA_UTL" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at "SYS.DBMS_REPCAT_MIG_INTERNAL", line 726
> ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 86
> ORA-06512: at line 1
> IMP-00017: following statement failed with ORACLE error 4068:
> "BEGIN SYS.DBMS_REPCAT_MIG.CLEANUP_IMPORT('EXPORT:V08.01.07'); END;"
> IMP-00003: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_REPCAT_SNA_UTL" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at "SYS.DBMS_REPCAT_MIG_INTERNAL", line 726
> ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 86
> ORA-06512: at line 1
> IMP-00009: abnormal end of export file
> IMP-00017: following statement failed with ORACLE error 4068:
> "BEGIN SYS.DBMS_REPCAT_MIG.POST_IMPORT; END;"
> IMP-00003: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SYS.DBMS_REPCAT_SNA_UTL" has errors
>
>
> I'm looking in the fine manuals but not finding much. Any info would be
> appreciated.
>
> Thanks,
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).