Results 1 to 3 of 3

Thread: Error with EXP

  1. #1
    Join Date
    Jun 2003
    Posts
    81

    Unanswered: Error with EXP

    I have a script that runs every night making a DUMP-file, but after several years without any errors, suddenly the script fails. I use EXP, but get the error:

    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
    ORA-06512: at "SYS.DBMS_METADATA", line 449
    ORA-06512: at "SYS.DBMS_METADATA", line 1156
    ORA-06512: at "SYS.DBMS_METADATA", line 1141
    ORA-06512: at line 1
    EXP-00000: Export terminated unsuccessfully

    I found a thread about the same error telling me to run the script $ORACLE_HOME/rdbms/admin/catmeta.sql connected as SYS. But that doesn't seems to have any impact.

    Please help!

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    I have seen this a few times in Oracle 9i databases where XML DB is installed. Exports fail after xmldb catalog corruption. Oracle support has a few notes on it with similar but not exact errors as you reported, fixed in 9206+. Did you recently install XML DB, or recently create XML objects in the database? If so, the fix is not pretty - drop the XMLDB schema and lose all your XML objects, then reload XMLDB (using either DBCA or catalog scripts.) However, doing so in a pre-9206 database will not resolve the problem for very long - it will come back until you upgrade the db.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Jun 2003
    Posts
    81
    My DB is now again available to export dump files. I was given a hint telling me to run $OH\rdbms\admin\catnoqm.sql (if I didn't use the XDB-option).

    After running this script, I can now make a full export.

    If I am going to use the XDB option, I can reinstall the option by using the script catqm.sql followed by catxdbj.sql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •