| Import Error. Why program unit is missing??? [message #54651] |
Mon, 25 November 2002 18:23  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
I'm getting the following errors in import and looks like a program unit is missing. Why is it missing? How do I get it back. I have installed almost everything that came with the CD.
IMP-00017: following statement failed with ORACLE error 4068:
IMP-00021: operating system error - error code (dec 2, hex 0x2)
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 49
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
|
|
|
|
| Re: Import Error. Why program unit is missing??? [message #54652 is a reply to message #54651] |
Mon, 25 November 2002 18:37  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
Actually, it looks like nothing is missing. But the package 'SYS.DBMS_REPCAT_MIG_INTERNAL' has compilation errors with a bunch of other packages.
How do you get the actual compilation error? Because, when I use 'alter package dbms_repcat_mig_internal compile' or 'compile body' I get only 'Warning: Package altered with compilation errors'. It doesn't point out which line or what is causing the error.
How do I get more details?
Thanks
|
|
|
|
| Re: Import Error. Why program unit is missing??? [message #54667 is a reply to message #54651] |
Tue, 26 November 2002 13:36 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Tony,
You can see the latest compilation errors from SQL*Plus by using SHOW ERRORS command.
Warning: Procedure created with compilation errors.
SQL> show errors
Errors for PROCEDURE ABC:
LINE/COL ERROR
-------- ----------------------------------------------------------------
3/1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of
the following:
( ; is with authid deterministic parallel_enable as compress
compiled wrapped
The symbol "is" was substituted for "BEGIN" to continue.
Or query USER_ , ALL_ , DBA_ERRORS views. Pay attention on the sequence column.
SQL> desc user_errors
Name Null? Type
----------------------------------------- -------- ---------------
NAME NOT NULL VARCHAR2(30)
TYPE VARCHAR2(12)
SEQUENCE NOT NULL NUMBER
LINE NOT NULL NUMBER
POSITION NOT NULL NUMBER
TEXT NOT NULL VARCHAR2(4000)
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
| Re: Import Error. Why program unit is missing??? [message #58487 is a reply to message #54651] |
Tue, 02 September 2003 16:45 |
jsadove
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
It looks like your running into the same problem as specified in Metalink Note 203317.1 (Import fails with IMP-00017 IMP-00003 ORA-04068).
The Note gives the solution:
--------------
This error may occur due to invalid replication packages
From svrmgrl,Please connect as internal .
Run the following scripts that resides under $ORACLE_HOME/rdbms/admin
1)catrepr.sql (Removes Replication related objects)
2)catrep.sql (Creates Replication related objects)
3)utlrp.sql (Recompile Invalid PL/SQL modules).
After this rerun the import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
