OraFAQ Forum: Server Utilities » export Fail - only answer this if you're a lazy arrogant SOB like me

Home » RDBMS Server » Server Utilities » export Fail - only answer this if you're a lazy arrogant SOB like me

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export Fail - only answer this if you're a lazy arrogant SOB like me [message #253871]

Wed, 25 July 2007 02:53

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

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: export Fail - Urgent [message #253881 is a reply to message #253874]

Wed, 25 July 2007 03:49

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

Report message to a moderator

Re: export Fail - Urgent [message #253885 is a reply to message #253881]

Wed, 25 July 2007 03:59

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you have several Oracle versions on your server?

Regards
Michel

Report message to a moderator

Re: export Fail - Urgent [message #253887 is a reply to message #253885]

Wed, 25 July 2007 04:02

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

NO

Report message to a moderator

Re: export Fail - Urgent [message #253891 is a reply to message #253887]

Wed, 25 July 2007 04:22

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post the 10 first lines of "exp help=y"

Regards
Michel

Report message to a moderator

Re: export Fail - Urgent [message #253894 is a reply to message #253891]

Wed, 25 July 2007 04:33

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

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

hi

Kindly help us

Report message to a moderator

Re: export Fail - Urgent [message #253920 is a reply to message #253907]

Wed, 25 July 2007 05:34

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: export Fail - Urgent [message #253922 is a reply to message #253920]

Wed, 25 July 2007 05:37

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

Report message to a moderator

Re: export Fail - Urgent [message #253935 is a reply to message #253922]

Wed, 25 July 2007 05:54

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

Report message to a moderator

Re: export Fail - Urgent [message #253960 is a reply to message #253922]

Wed, 25 July 2007 06:39

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: export Fail - Urgent [message #253971 is a reply to message #253960]

Wed, 25 July 2007 07:11

rrajesh_jain
Messages: 13
Registered: May 2007

Junior Member

oracle 8i

Report message to a moderator

Re: export Fail - Urgent [message #253980 is a reply to message #253971]

Wed, 25 July 2007 07:23

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: export Fail - Urgent [message #254160 is a reply to message #253980]

Thu, 26 July 2007 00:55

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

Report message to a moderator

Re: export Fail - Urgent [message #254170 is a reply to message #254160]

Thu, 26 July 2007 01:18

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: export Fail - Urgent [message #254176 is a reply to message #254170]

Thu, 26 July 2007 01:41

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Then Kindly suggest how to solved this problem

Thanks & Regards

Report message to a moderator

Re: export Fail - Urgent [message #254180 is a reply to message #254170]

Thu, 26 July 2007 01:47

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

Report message to a moderator

Re: export Fail - Urgent [message #254202 is a reply to message #254180]

Thu, 26 July 2007 02:45

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Kindly Help.....................

Report message to a moderator

Re: export Fail - Urgent [message #254298 is a reply to message #254202]

Thu, 26 July 2007 06:44

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi M

Are u Busy Today

Report message to a moderator

Re: export Fail - Urgent [message #254304 is a reply to message #254298]

Thu, 26 July 2007 06:53

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: export Fail - Urgent [message #254306 is a reply to message #254304]

Thu, 26 July 2007 06:58

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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Line break problem in sql loader
Next Topic:	error while importing the dump file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 21:56:07 CDT 2024