need to drop number of user from database

[suresh sargar]

hi All,

i need to drop my local database user as a part of test i tried to put "drop user "******" cascade in sql file and tried to run it;

but it's giving error stating that
*************************************************

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

***************************************************

please help me, what's may be cause?

thanks in advance

Suresh

[Jeanne Boyarsky]

Suresh,
Does the table/view exist? Does the user running the script have permission to drop it?

[Vamsi Mohan]

Please check wheather the tables or schema is using by other running applications or not. Use the dba user credentials to drop the user not with the user level permissions.

[suresh sargar]

i connected with SYS user ..still i am not able to drop the user.and how can i find it that any user is executing currently? if i restart the database will other execution get stop so that i can try to drop that user.

[Vamsi Mohan]

If you restart the database, all the connected users will be automatically disconnected. You can start droping the users.