Home » RDBMS Server » Server Administration » ORA-00604: error occurred at recursive SQL level 1 (10.2.0.2.0 RH AS4)
ORA-00604: error occurred at recursive SQL level 1 [message #361791] Fri, 28 November 2008 01:53 Go to next message
jeffy_bj
Messages: 6
Registered: November 2008
Location: beijing china
Junior Member

Dear all:
while I drop a table,I am getting following message.

SQL> drop table test02;
drop table test02
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows



ORACLE DOC tell me as following:

Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).

Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.


but I don't konw what I do. Please tell me.

Regards.
jeffy.
Re: ORA-00604: error occurred at recursive SQL level 1 [message #361793 is a reply to message #361791] Fri, 28 November 2008 01:57 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

How many rows do you have in the DUAL table ?

[Updated on: Fri, 28 November 2008 01:58]

Report message to a moderator

Re: ORA-00604: error occurred at recursive SQL level 1 [message #361795 is a reply to message #361791] Fri, 28 November 2008 02:00 Go to previous messageGo to next message
jeffy_bj
Messages: 6
Registered: November 2008
Location: beijing china
Junior Member

no rows.the table is empty.
Re: ORA-00604: error occurred at recursive SQL level 1 [message #361797 is a reply to message #361795] Fri, 28 November 2008 02:08 Go to previous messageGo to next message
jeffy_bj
Messages: 6
Registered: November 2008
Location: beijing china
Junior Member

I can create objects,can delete and update on any table,and I can drop indexes and procedures,but only can not drop table.
Re: ORA-00604: error occurred at recursive SQL level 1 [message #361800 is a reply to message #361797] Fri, 28 November 2008 02:15 Go to previous messageGo to next message
jeffy_bj
Messages: 6
Registered: November 2008
Location: beijing china
Junior Member

jesus ,2 rows in the DUAL table, I delete the additional one,and drop TEST02 table ,it is all rigth. thanks .
Re: ORA-00604: error occurred at recursive SQL level 1 [message #361802 is a reply to message #361800] Fri, 28 November 2008 02:20 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Good, because I got a bit confused when you said that you had no rows Wink
Re: ORA-00604: error occurred at recursive SQL level 1 [message #361806 is a reply to message #361802] Fri, 28 November 2008 02:25 Go to previous messageGo to next message
jeffy_bj
Messages: 6
Registered: November 2008
Location: beijing china
Junior Member

I said no rows in the TEST02 table Razz
tahpush,thank you very much.
Re: ORA-00604: error occurred at recursive SQL level 1 [message #361827 is a reply to message #361806] Fri, 28 November 2008 03:28 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Actually, you have reported message to a moderator saying that
Quote:
it has 1 column and 1 rows i,e x varchar2(1)

I guess this one is missing here.

Next time, please, reply to a message, don't report it.
Previous Topic: Test : Running many files simulation(!?)
Next Topic: Index problem after import using imp
Goto Forum:
  


Current Time: Sun Dec 04 22:40:37 CST 2016

Total time taken to generate the page: 0.22102 seconds