If you drop the schema. All the objects will be removed automatically.

No need to do anything



-----Original Message-----
From: shivas
[mailto:oracledba-ezmlmshield-x13284065.[Email address protected]
Sent: Wednesday, March 05, 2008 12:08 PM
To: LazyDBA Discussion
Subject: schema deleting !

Hi Guru's

scenario: I have schema SIVA under this schema i have 1000's of tables.

MyQustion is : If i delete schema SIva all the table form database will
drop or not. if not, i wat to drop all the table before deleting user.

Thanks

shiva.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page