Home » RDBMS Server » Server Administration » need guidelines to drop user in oracle (oracle 10.2.0.3 and solaris 10)
need guidelines to drop user in oracle [message #389571] Mon, 02 March 2009 12:43 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Hello experts,

i need to drop one user along with objects. i have some questions before drop the user.

what are the pre checks i need to perform.
what are the post check i need to perform after dropping user.

i am checking object status from dba_objects after dropping user. is it enough?

i am using following command to drop user with objects
drop user xxx cascade;


i have never drop user in the production database in the past. kindly provide some inputs.
Re: need guidelines to drop user in oracle [message #389572 is a reply to message #389571] Mon, 02 March 2009 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what are the pre checks i need to perform.

Nothing.

Quote:
what are the post check i need to perform after dropping user.

Nothing.

Theorically you should know why you drop the user and what are the dependencies of its objects WITHOUT checking anything in the database.

Regards
Michel

Re: need guidelines to drop user in oracle [message #389573 is a reply to message #389571] Mon, 02 March 2009 12:48 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>what are the pre checks i need to perform.
You need to have current backups with tested & documented recovery procedures?

Re: need guidelines to drop user in oracle [message #389578 is a reply to message #389573] Mon, 02 March 2009 13:10 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Also, you MIGHT just want to lock the user and/or change the password and wait a week if someone screams.
Re: need guidelines to drop user in oracle [message #389615 is a reply to message #389578] Mon, 02 March 2009 22:59 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>what are the pre checks i need to perform.

Take backup for your schema.

>>what are the post check i need to perform after dropping user.

After dropping user; what your going to check?? Nothing.

>>i am checking object status from dba_objects after dropping user. is it enough?

Yes It's enough.
Re: need guidelines to drop user in oracle [message #389618 is a reply to message #389571] Mon, 02 March 2009 23:01 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You might want to check for INVALID objects before & after DROP.
Previous Topic: Tablespace error
Next Topic: Database creation stopped
Goto Forum:
  


Current Time: Mon Dec 05 03:11:45 CST 2016

Total time taken to generate the page: 0.14618 seconds