You can't "delete" (DROP) a schema without specifying "CASCADE" which will
do the cleanup !

And if you do that "all the table from database" won't go away, only the
objects held by your schema/user will be affected.


hth
-Kris

-----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




Nous Infosystems:
This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual(s) or entity(ies) named in the e-mail address. If you are not the intended recipient, please reply to the [Email address protected] so that arrangements can be made for proper delivery, and then please delete all copies and attachments. Any disclosure, copying, distribution, or reliance upon the contents of this e-mail, by any other than the intended recipients, is strictly prohibited.

Oracle LazyDBA home page