Export Error, Exp-0056 , Ora-1422, Ora-6512

From: <kishanthakker_at_gmail.com>
Date: 30 Mar 2007 06:54:17 -0700
Message-ID: <1175262856.984946.180120@n59g2000hsh.googlegroups.com>

Dear friends,

I will be highly obliged if any one can help me on this error , which I M getting while trying to backup user wise data from oracle9i on Redhat Linux ES rel. 4.

While taking EXPORT backup on Oracle9i Enterprise Edition Release 9.2.0.4.0
I M getting following error message

. exporting triggers

EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "XDB.DBMS_XDBUTIL_INT", line 55
ORA-06512: at line 1
EXP-00056: ORACLE error 1422 encountered
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "XDB.DBMS_XDBUTIL_INT", line 55
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

I M taking backup with following command.

exp system/<password> file=<filename> log=<logfilename> owner=<username>

we have around 15 oracle users. All other export is terminated without error/warnings. Except only one user.

Once again I request to help me.

Thanx in Advance

Kishan Thakker Received on Fri Mar 30 2007 - 08:54:17 CDT