Home » SQL & PL/SQL » SQL & PL/SQL » Cannot drop table-Urgent
Cannot drop table-Urgent [message #20645] Mon, 10 June 2002 20:03 Go to next message
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.
Re: Cannot drop table-Urgent [message #20647 is a reply to message #20645] Mon, 10 June 2002 22:16 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Try not to post every question in multiple forums.

See reply in other forum.

Thx,
MHE
Re: Cannot drop table-Urgent [message #20650 is a reply to message #20645] Tue, 11 June 2002 05:19 Go to previous messageGo to next message
Jon
Messages: 483
Registered: May 2001
Senior Member
Try not to reply twice.
Try not to reply twice.
Re: Cannot drop table-Urgent [message #20671 is a reply to message #20645] Wed, 12 June 2002 18:32 Go to previous message
Su
Messages: 154
Registered: April 2002
Senior Member
Maaher, since it is urgent as he says, and to draw the attention whoever sees and answers the query at least in one forum (if some one who misses in another), the people normally (some times) would post in multiple forums. But your answer hurts the feelings of the one who posted it. Try to understand. And you did not mention, which forum is it. You just mentioned, 'See reply in other forum'. And dont always assume your answer to the query impressed or worked for the one who posted it. Please be advised, be professional and polite. Remember, this is a public forum.
Keep smiling.

Good luck :)
Previous Topic: PL/SQL
Next Topic: Length is null
Goto Forum:
  


Current Time: Thu Mar 28 11:01:28 CDT 2024