Export DB Problem
DBAsupport.com Forums - Powered by vBulletin

View Poll Results: Export DB Problem

Voters
0. You may not vote on this poll
  • Error " exporting cluster definitions"

    0 0%
  • EXP-00056: ORACLE error 19206 encountered

    0 0%
  • ORA-19206: Invalid value for query or REF CURSOR parameter

    0 0%
  • ORA-06512: at "SYS.DBMS_METADATA", line 345

    0 0%
Results 1 to 6 of 6

Thread: Export DB Problem

  1. #1
    Join Date
    Mar 2003
    Location
    Gujarat
    Posts
    19

    Export DB Problem

    I am facing problem in Export db
    Error Details
    " exporting cluster definitions
    EXP-00056: ORACLE error 19206 encountered
    ORA-19206: Invalid value for query or REF CURSOR parameter
    ORA-06512: at "SYS.DBMS_XMLGEN", line 83
    ORA-06512: at "SYS.DBMS_METADATA", line 345
    ORA-06512: at "SYS.DBMS_METADATA", line 410"

    Please advice.
    regs
    ramji

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Connect as sys and run

    SQL> @?/rdbms/admin/catmeta.sql

    Then do the export again.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: Export DB Problem

    Hi,
    XDB installation/dictionary built causes some of the underlying XML views to be INVALID. Here the error occurs when dbms_xmlgen tries to access one those invalid views.
    Run the following script that resides under $ORACLE_HOME/rdbms/admin directory after XDB dictionary is built by connecting as user SYS : catmeta.sql (Creates Object Model of Oracle dictionary).After running this script, start the export of database again.

    Regards,
    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  4. #4
    Join Date
    Mar 2003
    Location
    Gujarat
    Posts
    19
    Dear all ,

    Thanks for valuable support from team.
    i hv run catmeta.sql
    the problem get resolved but one worning message has came at every table

    " EXP-00091: Exporting questionable statistics.

    . . exporting table TOOLTRANS 2 rows exported

    Please advise...

    Regards
    Ramji

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by ramji
    Dear all ,

    Thanks for valuable support from team.
    i hv run catmeta.sql
    the problem get resolved but one worning message has came at every table

    " EXP-00091: Exporting questionable statistics.

    . . exporting table TOOLTRANS 2 rows exported

    Please advise...

    Regards
    Ramji
    in the exp command add statistics=none

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Mar 2003
    Location
    Gujarat
    Posts
    19
    Thanks Problem resolved.
    regs
    ramji

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