Error in export (EXP-00097)
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 ...
Have you investigated why you have an invalid system owned object?
Dont know when it started....recently noticed this warning...Pls advice how to investigate. Cannot find any information in alert and trace files.
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.
Rohit S Nirkhe
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)
Click Here to Expand Forum to Full Width