Operating System - HP-UX
1748027 Members
4946 Online
108757 Solutions
New Discussion юеВ

Oracle exp - returns error --> exact fetch returns more ...

 
SOLVED
Go to solution
Stephen Badgett
Regular Advisor

Oracle exp - returns error --> exact fetch returns more ...

exp - exact fetch returns more than ...

When attempting exp -->>( exp usrreg/bla file=/tmp/reg.dmp ) We get this error ...

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


Not as is, is now
6 REPLIES 6
TwoProc
Honored Contributor

Re: Oracle exp - returns error --> exact fetch returns more ...

Seems to be a bug that was fixed in version 9.2.0.4 and higher - however, I did see someone mention a problem in one case that was already at 9.2.0.4. Are you on 9.2.0.3 or below?
We are the people our parents warned us about --Jimmy Buffett
Stephen Badgett
Regular Advisor

Re: Oracle exp - returns error --> exact fetch returns more ...

We are currently on 9.2.0.4
Not as is, is now
TwoProc
Honored Contributor

Re: Oracle exp - returns error --> exact fetch returns more ...

Sorry then, I got a hit on Metalink for 9.2.0.3 and below (I remembered seeing it way back when). But, you're not the only one who still saw/sees he problem into 9.2.0.4.
We are the people our parents warned us about --Jimmy Buffett
TwoProc
Honored Contributor
Solution

Re: Oracle exp - returns error --> exact fetch returns more ...

OK, on OTN.oracle.com - in a forum thread. One person posted an exact issue like yours, and the response was:

there is a simple answer documented on Metalink for this problem.

Check your triggers and object names - there is a conflict .

OK, so I didn't find the "simple answer" on Metalink - but it gives you something to go on. See if you've got a trigger and an object name that are the same, focusing on the schema that was being exported at the time.
We are the people our parents warned us about --Jimmy Buffett
Stephen Badgett
Regular Advisor

Re: Oracle exp - returns error --> exact fetch returns more ...

trigger conflict- thank you
Not as is, is now
Stephen Badgett
Regular Advisor

Re: Oracle exp - returns error --> exact fetch returns more ...

Trigger conflict
Not as is, is now