error while export in oracle 9.2.0.4
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: error while export in oracle 9.2.0.4

  1. #1
    Join Date
    Nov 2005
    Posts
    32

    error while export in oracle 9.2.0.4

    Hi all

    while full export in oracle 9.2.0.4 I am getting error
    .
    .
    .
    while exporting triggers .....
    Exp-00056 : Error 1422 encountered
    ora-01422 : exact fetch return more than expected rows
    ora-06512 :at "XDB.DBMS_XDBUTIL_INT", line 55
    ora-06512 :at line 1
    but if take the export remotely from oracle 9.2.0.1
    the error does not occure and successfull

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Recreate the package DBMS_XDBUTIL_INT in XDB schema.
    This is where you will get it
    $ORACLE_HOME/rdbms/admin/prvtxdb.plb
    btw: are you using XML database?.If not ,you should remove XDB Schema
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  3. #3
    Join Date
    Nov 2005
    Posts
    32
    Hi simply_dba
    Thankx for reply
    but the thing is ,we have scheduled daily export and this error does not occures frequently ,if it has any error than why export suceeded normally .i take remote export than it does not give me any error ( from 9.2.0.1) .
    another thing, if any package/procedure/trigger have any compilataion error then it should export with warning ,why it halted after error.

    we are not using xml database
    thanks & regards

  4. #4
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    You may be encountering bugs.
    Actually, you can create triggers having same name as tables under the same owner,but this fact is not considered in the package( and that is why exact fetch returns more than one row).
    Read note 256548.1 in metalink for full explanation
    Last edited by simply_dba; 12-27-2006 at 05:36 AM.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  5. #5
    Join Date
    Nov 2005
    Posts
    32
    Hi simply Friend
    .....But i am confuse
    i am trying to export only xdb user then i am facing error like user does not exist or wrong users (on linux9 as OS and oracle 9.2.0.4)
    otherwise i am able to connect this user
    ...but i export remotly from windows Xp and oracle 9.2.0.1 it does not produce any error

  6. #6
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    i am trying to export only xdb user then i am facing error like user does not exist or wrong users (on linux9 as OS and oracle 9.2.0.4)
    Have you read the documents i have suggested?

    btw: you cannot export the metadata of XDB repository as it oracle does not support its structure
    Oracle will skip the following schemas during full database export ;
    'ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS','LBACSYS', 'XDB'
    These schemas are not included in the views required by export and import utilities ( that is why the message 'user does not exist'). Have a look at your catexp.sql
    Last edited by simply_dba; 01-02-2007 at 04:39 AM.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

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