OraFAQ Forum: Server Utilities » Export fail - oracle 8i

Home » RDBMS Server » Server Utilities » Export fail - oracle 8i

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

Export fail - oracle 8i [message #240063]

Thu, 24 May 2007 01:11

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi Dears

I m using oracle 8.1.5 and while taking the export i m getting the following error. Kindly suggest

I have rerun the catalog and cataproc but error remain same

. 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

Regards

Tarun Mittal
9891355809

Report message to a moderator

Re: Export fail - oracle 8i [message #240070 is a reply to message #240063]

Thu, 24 May 2007 01:25

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

Senior Member
Account Moderator

Are you exporting from the database server or from a client?
Post your export command.

If this is from a client what the client Oracle version?

Regards
Michel

[Updated on: Thu, 24 May 2007 01:26]

Report message to a moderator

Re: Export fail - oracle 8i [message #240505 is a reply to message #240070]

Fri, 25 May 2007 01:53

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi

I m exporting from server

command which i used

exp newton/newton file=25052007.dmp log=newton.log buffey=999999 feedback=2000

regards

Tarun Mittal

Report message to a moderator

Re: Export fail - oracle 8i [message #240509 is a reply to message #240505]

Fri, 25 May 2007 02:02

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

Senior Member
Account Moderator

There are known bug in 8.1.5 if you have Java objects.
You then have to upgrade 8.1.7.

Regards
Michel

Report message to a moderator

Re: Export fail - oracle 8i [message #240511 is a reply to message #240509]

Fri, 25 May 2007 02:04

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Thanks for reply

There is no java objects.

Regards

TKM

Report message to a moderator

Re: Export fail - oracle 8i [message #240535 is a reply to message #240511]

Fri, 25 May 2007 03:16

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

Senior Member
Account Moderator

Execute:

SELECT MAX(LEVEL),d_obj#
FROM sys.DEPENDENCY$
CONNECT BY d_obj# = PRIOR p_obj#
GROUP BY d_obj#;

Do you get an error?

Regards
Michel

Report message to a moderator

Re: Export fail - oracle 8i [message #240546 is a reply to message #240063]

Fri, 25 May 2007 03:26

sujeetsaxena16
Messages: 9
Registered: May 2007
Location: mumbai

Junior Member

PLz write the following command for takig export and tell me the result.

exp system file=exp.dmp log=exp.log full=y feedback=10000 direct=y rows=y

Report message to a moderator

Re: Export fail - oracle 8i [message #240598 is a reply to message #240535]

Fri, 25 May 2007 05:12

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi

I got the error

SQL> SELECT MAX(LEVEL),d_obj# FROM sys.DEPENDENCY$ CONNECT BY d_obj# = PRIOR p_obj# GROUP BY d_obj#;
SELECT MAX(LEVEL),d_obj# FROM sys.DEPENDENCY$ CONNECT BY d_obj# = PRIOR p_obj# GROUP BY d_obj#
*
ERROR at line 1:
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

Report message to a moderator

Re: Export fail - oracle 8i [message #240602 is a reply to message #240546]

Fri, 25 May 2007 05:17

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

i m getting the same error msg

kindly suggest

Report message to a moderator

Re: Export fail - oracle 8i [message #240609 is a reply to message #240602]

Fri, 25 May 2007 05:25

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

Senior Member
Account Moderator

I don't understand the message you should have only:

SQL> SELECT MAX(LEVEL),d_obj# FROM sys.DEPENDENCY$ CONNECT BY d_obj# = PRIOR p_obj# GROUP BY d_obj#; 
SELECT MAX(LEVEL),d_obj# FROM sys.DEPENDENCY$ CONNECT BY d_obj# = PRIOR p_obj# GROUP BY d_obj#
                                  *
ERROR at line 1:
ORA-01436: CONNECT BY loop in user data

without the lines:

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

However that may be, there is nothing to do but upgrade to 8.1.7.

Regards
Michel

Report message to a moderator

Re: Export fail - oracle 8i [message #240615 is a reply to message #240609]

Fri, 25 May 2007 05:49

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Thanks for u reply

But my same application having the same database,same datafile, tablespace even same objetcs with same schema running on different side which is working absoulty fine.

so plz help me.

Regards

Tarun Mittal

Report message to a moderator

Re: Export fail - oracle 8i [message #240630 is a reply to message #240615]

Fri, 25 May 2007 06:31

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

Senior Member
Account Moderator

This is the problem with a bug.
It fires under some conditions but till you don't know which ones you can't do anything.
Oracle does not publish why there is a bug, they only deliver correction.
Can't help you more.

Regards
Michel

Report message to a moderator

Re: Export fail - oracle 8i [message #240646 is a reply to message #240609]

Fri, 25 May 2007 07:16

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

This error comes many time like when we enter worng user name or if we run some specific report or we can say any time

However at the time of wrong user enter it should give invalid user name/password but it gives

ORA-00604: error occurred at recursive SQL level 1

so kindly confirm me it's is bug

can u give me bug id

Thanks for u r support

Regards

Tarun

Report message to a moderator

Re: Export fail - oracle 8i [message #240656 is a reply to message #240646]

Fri, 25 May 2007 07:42

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

Senior Member
Account Moderator

I can't confirm it.
It seems to be a bug.
You're using a version that is no more since last century. Who can remember which bug it is?

Have a look if you have any trigger on DDL, database, or the like.

Regards
Michel

Report message to a moderator

Re: Export fail - oracle 8i [message #240810 is a reply to message #240656]

Fri, 25 May 2007 23:57

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi Dear

I m not geeting this what r u try to say. Kindly explain

Have a look if you have any trigger on DDL, database, or the like

In my datababse we have trigger's.

Regards

Tarun Mittal

Report message to a moderator

Re: Export fail - oracle 8i [message #240811 is a reply to message #240810]

Sat, 26 May 2007 00:11

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

Senior Member
Account Moderator

Post the result of:

set linesize 120
col triggering_event format a40
select owner, trigger_type, triggering_event, count(*) nb
from dba_triggers
group by owner, trigger_type, triggering_event
order by owner, trigger_type, triggering_event
/

And post it formatted. Read How to format your posts

Regards
Michel

Report message to a moderator

Previous Topic:	Changing Characterset from AL16UTF16 to AL32UTF8
Next Topic:	importing in 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 00:23:35 CDT 2024