OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » drop a table

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

drop a table [message #138350]

Wed, 21 September 2005 08:50

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

hii
i have a user "pis_try"
i droped from it all its tables by using
that sql command:

select 'drop table '||table_name||';' from user_tables;

after that i tried to drop the user by using that sql command:

drop user pis_try cascade;

but it gives me those errors:

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01418: specified index does not exist

all i want to do is to drop that user after these situations

thx

Report message to a moderator

Re: drop a table [message #138352 is a reply to message #138350]

Wed, 21 September 2005 08:53

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Oracle version / OS?
It is reported bug in the earlier versions.

Report message to a moderator

Re: drop a table [message #138445 is a reply to message #138350]

Thu, 22 September 2005 01:17

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

my oracle version is "Oracle8i Release 8.1.7.0.0"

Report message to a moderator

Re: drop a table [message #138452 is a reply to message #138350]

Thu, 22 September 2005 01:52

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

plz reply ?
what can i do to drop that user

Report message to a moderator

Re: drop a table [message #138869 is a reply to message #138452]

Sat, 24 September 2005 15:06

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Check for any objects that are existing in dba_objects that are existing in this user and try to drop them ..but as mahesh said , ultimately this boils down a bug in Oracle - which might need a patch / upgrade

-Sai

Report message to a moderator

Previous Topic:	size of the sga
Next Topic:	application hangs..!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 10:51:56 CST 2025