Home » RDBMS Server » Server Utilities » Export fail - oracle 8i
Export fail - oracle 8i [message #240063] Thu, 24 May 2007 01:11 Go to next message
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
Re: Export fail - oracle 8i [message #240070 is a reply to message #240063] Thu, 24 May 2007 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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 Go to previous messageGo to next message
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
Re: Export fail - oracle 8i [message #240509 is a reply to message #240505] Fri, 25 May 2007 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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
Re: Export fail - oracle 8i [message #240511 is a reply to message #240509] Fri, 25 May 2007 02:04 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Thanks for reply

There is no java objects.

Regards

TKM
Re: Export fail - oracle 8i [message #240535 is a reply to message #240511] Fri, 25 May 2007 03:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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
Re: Export fail - oracle 8i [message #240546 is a reply to message #240063] Fri, 25 May 2007 03:26 Go to previous messageGo to next message
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
Re: Export fail - oracle 8i [message #240598 is a reply to message #240535] Fri, 25 May 2007 05:12 Go to previous messageGo to next message
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
Re: Export fail - oracle 8i [message #240602 is a reply to message #240546] Fri, 25 May 2007 05:17 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
i m getting the same error msg

kindly suggest
Re: Export fail - oracle 8i [message #240609 is a reply to message #240602] Fri, 25 May 2007 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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

Re: Export fail - oracle 8i [message #240615 is a reply to message #240609] Fri, 25 May 2007 05:49 Go to previous messageGo to next message
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


Re: Export fail - oracle 8i [message #240630 is a reply to message #240615] Fri, 25 May 2007 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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
Re: Export fail - oracle 8i [message #240646 is a reply to message #240609] Fri, 25 May 2007 07:16 Go to previous messageGo to next message
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

Re: Export fail - oracle 8i [message #240656 is a reply to message #240646] Fri, 25 May 2007 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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

Re: Export fail - oracle 8i [message #240810 is a reply to message #240656] Fri, 25 May 2007 23:57 Go to previous messageGo to next message
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
Re: Export fail - oracle 8i [message #240811 is a reply to message #240810] Sat, 26 May 2007 00:11 Go to previous message
Michel Cadot
Messages: 64110
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
Previous Topic: Changing Characterset from AL16UTF16 to AL32UTF8
Next Topic: importing in 9i
Goto Forum:
  


Current Time: Mon Dec 05 11:16:14 CST 2016

Total time taken to generate the page: 0.15017 seconds