OraFAQ Forum: Server Administration » Cannot drop table-Urgent

Home » RDBMS Server » Server Administration » Cannot drop table-Urgent

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

Cannot drop table-Urgent [message #51723]

Mon, 10 June 2002 20:01

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Hi,
I have a user named us01 who has connect,resource and DBA roles. Problem i am facing is that this user can create a table but cannot drop it. The error its giving is ORA-0604. However, if i connect thru system/manager i am able to drop the table. Pls help.

Thanks in advance
ManishM.

Report message to a moderator

Re: Cannot drop table-Urgent [message #51726 is a reply to message #51723]

Mon, 10 June 2002 22:06

Maaher
Messages: 7065
Registered: December 2001

Senior Member

ORA-00604 error occurred at recursive SQL level string
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 Customer Support.

So my question is: What's the other Oracle error you encounter (if any)?

MHE

Report message to a moderator

Re: Cannot drop table-Other errors [message #51729 is a reply to message #51723]

Mon, 10 June 2002 22:34

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

Hi Maaher,
Thanks for your reply. The errors are given below.
regds
ManishM.
drop table a
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-21000: error number argument to raise_application_error of -2040505 is out of range
ORA-06512: at line 2

Report message to a moderator

Re: Cannot drop table-Other errors [message #51734 is a reply to message #51723]

Tue, 11 June 2002 03:11

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Check Metalink, there are several issues concerning recursive SQL and DROP.
One of the reasons could be that the maximum open cursors has been exceeded.

Check dependency$ for this object_id:
select * from dependency$ where D_OBJ# = your_id;
AND
select count(*) from dependency$ where p_OBJ# = your_id;
Then check all its dependencies within this view as d_obj#.

Make sure the user has the privilege to drop the table.

If that doesn't help, I suggest you call Oracle Support.

HTH,
MHE

Report message to a moderator

Previous Topic:	dba vs appsDBA
Next Topic:	import question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:29:24 CDT 2024