Try this:

Drop tablespace <tablespace name> including contents cascade constraints

This will drop the tablespace and all its contents.

Thanks.


Pamela

-----Original Message-----
From: muthiahplv
[mailto:oracledba-ezmlmshield-x15271078.[Email address protected]
Sent: Friday, October 29, 2004 9:45 AM
To: LazyDBA Discussion
Subject: How to delete Tablespace

Hi all,

Any on can help me in dropping tablespace in oracle8 running in
Sun Solaris.

With thanks
Muthiaha PV


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page