Exporting giving Error ...!Urgent pls [message #69414] |
Fri, 28 December 2001 19:11 |
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 #69418 is a reply to message #69414] |
Mon, 31 December 2001 21:06 |
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 |
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
----------------------------------------------------------------------
|
|
|