HELP...EXPORT error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: HELP...EXPORT error

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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...

    thanks
    ron


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

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

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


    Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - 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
    Posts
    807
    See Note:206313.1 on metalink.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

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

    Cause:
    ------
    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.

    Fix:
    ----
    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