Home » RDBMS Server » Server Utilities » import error
import error [message #70463] Mon, 17 June 2002 12:44 Go to next message
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?
Re: import error [message #70468 is a reply to message #70463] Mon, 17 June 2002 23:34 Go to previous messageGo to next message
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
Re: import error [message #70487 is a reply to message #70463] Thu, 20 June 2002 05:11 Go to previous messageGo to next message
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
Re: import error [message #239430 is a reply to message #70463] Tue, 22 May 2007 07:12 Go to previous messageGo to next message
jayabalraja
Messages: 1
Registered: May 2007
Location: CHENNAI
Junior Member

Hi try to run catexp.sql and utlrp.sql and then try import activity..

Re: import error [message #239462 is a reply to message #239430] Tue, 22 May 2007 08:14 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
I doubt that repeating the answer others have given 5 years after it was asked would be of any use. Odd choice for your first post.
Previous Topic: Import database to UNIX
Next Topic: impdp Import of table having object types of other schema
Goto Forum:
  


Current Time: Sun Dec 04 15:04:49 CST 2016

Total time taken to generate the page: 0.08344 seconds