-
Error in export (EXP-00097)
Hi,
I am getting an error in export. The export completes successfully with warnings. Any ideas how to fix it...
Copy of the error message:
-------------------------
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
EXP-00097: Object type "SYSTEM"."AQ$_JMS_OBJECT_MESSAGE" is not in a valid state, type will not be exported
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Direct Path ...
Many Thanks,
-
Have you investigated why you have an invalid system owned object?
Bazza
-
Hi,
Dont know when it started....recently noticed this warning...Pls advice how to investigate. Cannot find any information in alert and trace files.
Many Thanks,
-
Hi.
The object type "SYSTEM"."AQ$_JMS_OBJECT_MESSAGE" is not in a valid state, so it will not be exported.To resolve this issue either compile this object or use the toid_novalidate=(SYS.aq$_jms_object_message) in the export command so that you can skip validation of specified type ids.
Regards
Rohit S Nirkhe
-
Hi,
Added the following in the export command. The export fails and says its an unknown parameter.
exp system/@develop file=d:\DEV_schema.dmp direct=y compress=n rows=n Full=Y toid_novalidate=(SYS.aq$_jms_object_message)
Many Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|