Error in export (EXP-00097)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Error in export (EXP-00097)

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    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,

  2. #2
    Join Date
    Jul 2002
    Posts
    335
    Have you investigated why you have an invalid system owned object?

    Bazza

  3. #3
    Join Date
    Jan 2003
    Posts
    141
    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,

  4. #4
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  5. #5
    Join Date
    Jan 2003
    Posts
    141
    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
  •  


Click Here to Expand Forum to Full Width