DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002

    HELP...EXPORT error

    hello all,,

    Iam trying to do an EXP on Oracle92 database using Oracle92 Client....Iam getting the floowing error...any help is appreciated...


    C:\oracle\oracle92\bin>exp system/manager@dpiqa file=c:\aaa.dmp owner=fvierlin

    Export: Release - Production on Fri Sep 10 12:36:48 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Connected to: Oracle9i Enterprise Edition Release - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release - Production
    Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    server uses WE8ISO8859P1 character set (possible charset conversion)

    About to export specified users ...
    . exporting pre-schema procedural objects and actions
    . exporting foreign function library names for user FVIERLIN
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions for user FVIERLIN
    About to export FVIERLIN's objects ...
    . exporting database links
    . exporting sequence numbers
    . 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
    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


  2. #2
    Join Date
    Oct 2002
    See Note:206313.1 on metalink.

  3. #3
    Join Date
    Sep 2002

  4. #4
    Join Date
    May 2002
    For those with inquiring minds and who do not have access to MetaLink:

    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.

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

By using this site, you agree to the Privacy Policy