Home » SQL & PL/SQL » SQL & PL/SQL » how to drop all objects in one statement in a user
how to drop all objects in one statement in a user [message #20500] Thu, 30 May 2002 06:51 Go to next message
vimal
Messages: 46
Registered: February 2000
Member
hello friends
i have a dummy user for testing and have to import the latest dmp file into this user.
for this i have to drop the previous user, and then create a new user and grant priviledges to the new user and then have to take import this is quite lengthy process i want to know is there any procedure in which i dont have to go thru this lengthy process may be u will help me in this

pls sort it out
Re: how to drop all objects in one statement in a user [message #20505 is a reply to message #20500] Thu, 30 May 2002 11:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
why is it required to drop the user every time?
why not just drop the objects.
Re: how to drop all objects in one statement in a user [message #20511 is a reply to message #20500] Thu, 30 May 2002 12:10 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Just drop the objects. Go here and download a script called drop_user_objects.sql.

http://www.oriolecorp.com/frameindexSA.html
Previous Topic: Abt optimizer
Next Topic: DBMS_OUTPUT.GET_LINES Usage
Goto Forum:
  


Current Time: Thu Apr 18 17:55:46 CDT 2024