Home » RDBMS Server » Server Utilities » Exporting giving Error ...!Urgent pls
Exporting giving Error ...!Urgent pls [message #69414] Fri, 28 December 2001 19:11 Go to next message
suhi
Messages: 1
Registered: December 2001
Junior Member
Hi Everybody,

While exporting in FULL database i am getting following errors.
while at the time of database creation i got errors
while running catproc.sql .It is creating all packages and sps properly.
----

. exporting referential integrity constraints
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 781
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

pls any body can help me ?It's very urgent ..

thank you all
suchi

----------------------------------------------------------------------
Re: Exporting giving Error ...!Urgent pls [message #69415 is a reply to message #69414] Fri, 28 December 2001 21:16 Go to previous messageGo to next message
Sachin
Messages: 52
Registered: May 2001
Member
u can first check is there any compilation errors in package? if than correct it and after take export

----------------------------------------------------------------------
Re: Exporting giving Error ...!Urgent pls [message #69418 is a reply to message #69414] Mon, 31 December 2001 21:06 Go to previous messageGo to next message
AV.NACHIAPPAN
Messages: 9
Registered: December 2001
Junior Member
Please run the script catexp.sql
also inform what type of error you got while
creating the database?
if you provide details i will try to give a
solution.

Also go through the error messages in Help File
there they might have given some useful tips to
solve the problem.

----------------------------------------------------------------------
Re: Exporting giving Error ...!Urgent pls [message #69428 is a reply to message #69418] Fri, 04 January 2002 00:42 Go to previous message
Suchi
Messages: 6
Registered: December 2001
Junior Member
Hi

while creating database for some packages
it's giving "package created with compilation errors"
i am running catalog.sql
and catproc.sql.

catalog.sql in turn calls catexp.sql no need
to call that file know..
now it's giving following error.

EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: has errors
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SYS_SQL", line 781
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

Thank you
suchi

----------------------------------------------------------------------
Previous Topic: Re: FREE OCP PAPERS
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Fri Mar 29 03:29:09 CDT 2024