Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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