OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import error [message #70463]

Mon, 17 June 2002 12:44

Abu 'Ubaidah
Messages: 6
Registered: June 2002

Junior Member

I run Oracle 8.1.6 on Tru64 Unix and during a schema import i got:
IMP-00017 following stmt failed with ora 1403
BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;
IMP-00003 ORACLE ERROR 1403 encounted
ora-01403 no data found
ora-06512 at "SYS.DBMS_REPCAT_DECL",line 8
ora-06512 at "SYS.DBMS_REPCAT_MIG", LINE 94
ORA-06512 AT LINE 1

I recall that earlier when i was exporting the schema i got:
ora-04068 SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp has errors.

Will any good fellow help me?

Report message to a moderator

Re: import error [message #70468 is a reply to message #70463]

Mon, 17 June 2002 23:34

Sreedhar
Messages: 30
Registered: March 2000

Member

Did u ran the Catexp.sql...? seeems export related veiws are not installed... ir you are not taking the exp first.. time let me know.. I will give you anothere info..

-Sreedhar

Report message to a moderator

Re: import error [message #70487 is a reply to message #70463]

Thu, 20 June 2002 05:11

abdul
Messages: 18
Registered: May 2001

Junior Member

Hi Sreedhar,

Thanks, it is the first time i'm doing a schema export
but i have also been doing a table-level export successfully.

Anyhow, upon your advice i did run catexp.sql but i still got the error detailed below:

. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REFRESH_EXP_LWM" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.s
chema_info_exp
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_RGT_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.sc
hema_info_exp

Report message to a moderator