Home » RDBMS Server » Server Utilities » export Fail - only answer this if you're a lazy arrogant SOB like me
export Fail - only answer this if you're a lazy arrogant SOB like me [message #253871] Wed, 25 July 2007 02:53 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi Dear

i m using oracle 10g release 2

O/s : windows 2000 server

i m geeting the error while exporting

rows exported
. exporting synonyms
. exporting views
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-01436: CONNECT BY loop in user data
EXP-00000: Export terminated unsuccessfully


Kindly Help


Regards


Tarun Mittal

[mod-edit] removed the asinine arrogant demand for action on this.

[Updated on: Wed, 25 July 2007 08:04] by Moderator

Report message to a moderator

Re: export Fail - Urgent [message #253874 is a reply to message #253871] Wed, 25 July 2007 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ What was the export command you executed?
2/ What is your version with 4 decimals?
3/ Is this a database created in the current version or is this and upgraded database (created in a previous version)?

Regards
Michel
Re: export Fail - Urgent [message #253881 is a reply to message #253874] Wed, 25 July 2007 03:49 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
exp file=230707.dmp log=error.log buffer=99999 owner=test feedback=1000

oracle 10.2.0.1

Database created on same version
Re: export Fail - Urgent [message #253885 is a reply to message #253881] Wed, 25 July 2007 03:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have several Oracle versions on your server?

Regards
Michel
Re: export Fail - Urgent [message #253887 is a reply to message #253885] Wed, 25 July 2007 04:02 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
NO
Re: export Fail - Urgent [message #253891 is a reply to message #253887] Wed, 25 July 2007 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the 10 first lines of "exp help=y"

Regards
Michel
Re: export Fail - Urgent [message #253894 is a reply to message #253891] Wed, 25 July 2007 04:33 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
By Mistake i mentioned the database vesion 10g but actual it is
oracle 8i so please help me

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>exp

Export: Release 8.1.5.0.0 - Production on Wed Jul 25 13:13:47 2007

(c) Copyright 1999 Oracle Corporation. All rights reserved.


Username: sys/oracle@oracle as sysdba

Connected to: Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
Enter array fetch buffer size: 4096 >

[moderator: remove ininteresting lines]

. . exporting table SWAMY_PARTY_M 4136 rows exported
. exporting synonyms
. exporting views
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-01436: CONNECT BY loop in user data
EXP-00000: Export terminated unsuccessfully

C:\>

[Updated on: Wed, 25 July 2007 05:35] by Moderator

Report message to a moderator

Re: export Fail - Urgent [message #253907 is a reply to message #253894] Wed, 25 July 2007 05:17 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
hi

Kindly help us
Re: export Fail - Urgent [message #253920 is a reply to message #253907] Wed, 25 July 2007 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So I can estimate that all what you said is false.
Reply all my questions and reply to them.

Regards
Michel
Re: export Fail - Urgent [message #253922 is a reply to message #253920] Wed, 25 July 2007 05:37 Go to previous messageGo to next message
rrajesh_jain
Messages: 13
Registered: May 2007
Junior Member
No only database version i mentioned was written by mistake

all other reply ====== TRUE


PLZ HELP
Re: export Fail - Urgent [message #253935 is a reply to message #253922] Wed, 25 July 2007 05:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

rrajesh_jain wrote on Wed, 25 July 2007 16:37
No only database version i mentioned was written by mistake

all other reply ====== TRUE


PLZ HELP



Laughing Laughing Laughing
Re: export Fail - Urgent [message #253960 is a reply to message #253922] Wed, 25 July 2007 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In which version the database was created? 10g or 8i or other version?

Regards
Michel
Re: export Fail - Urgent [message #253971 is a reply to message #253960] Wed, 25 July 2007 07:11 Go to previous messageGo to next message
rrajesh_jain
Messages: 13
Registered: May 2007
Junior Member
oracle 8i
Re: export Fail - Urgent [message #253980 is a reply to message #253971] Wed, 25 July 2007 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Upgrade to a newer version or drop the objects that generates the error in sys.dependency$ (something like view that references views that reference view that reference the first view).

Regards
Michel
Re: export Fail - Urgent [message #254160 is a reply to message #253980] Thu, 26 July 2007 00:55 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M


If i export the schema which does n't have any views then our export is success.

Can we drop those views because my export fail while exporing the views.

Can we drop those views, created in sys schema we have views named _All_REPCOLUMN in sys schema. What's the use of this views.



Thnaks for Reply

Regards

Tarun Mittal
Re: export Fail - Urgent [message #254170 is a reply to message #254160] Thu, 26 July 2007 01:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know its use but never touch SYS schema unless Oracle supports tell it.
SYS schema is not yours, it is Oracle's.

Regards
Michel
Re: export Fail - Urgent [message #254176 is a reply to message #254170] Thu, 26 July 2007 01:41 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Then Kindly suggest how to solved this problem

Thanks & Regards
Re: export Fail - Urgent [message #254180 is a reply to message #254170] Thu, 26 July 2007 01:47 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
One more thing i want to bring in u r knowlodge that whenever any error come then these three line of error also come with that error.

ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8


Kindly Suggest
Re: export Fail - Urgent [message #254202 is a reply to message #254180] Thu, 26 July 2007 02:45 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Kindly Help.....................
Re: export Fail - Urgent [message #254298 is a reply to message #254202] Thu, 26 July 2007 06:44 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

Are u Busy Today
Re: export Fail - Urgent [message #254304 is a reply to message #254298] Thu, 26 July 2007 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm always, I take time on my work, on my rest to help you, so keep patient.
You have a very very old version with many bugs.
My advice is to upgrade.
I don't have your schemas, I can't make queries on your dictionary to find where it fails.
It is a recursive, I can't give each and every statement.
Upgrade or hire a consultant to make the job.

Regards
Michel
Re: export Fail - Urgent [message #254306 is a reply to message #254304] Thu, 26 July 2007 06:58 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
i do n't want each and every step from u.

plz just give suggestion or idea except upgrade.


Thanks for u r suggestion for hire the consultant. ---- nice


Re: export Fail - only answer this if you're a lazy arrogant SOB like me [message #254328 is a reply to message #253871] Thu, 26 July 2007 08:00 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
My guess .. and it is just that a guess .. is that you have created a view which if you tried to query from it would give the same error.
Previous Topic: Line break problem in sql loader
Next Topic: error while importing the dump file
Goto Forum:
  


Current Time: Fri Dec 09 08:04:04 CST 2016

Total time taken to generate the page: 0.07914 seconds