Re: Drop tablespace

Hi

if the tablespace has anything in it and you are sure that you wnat to delete these objects then do

drop tablespace {tablespace_name} drop including contents;

If you have constraints on those objects you may need to remove those first.

cheers

Pete Finnigan
www.pentest-limited.com

In article <9kfl08$up2$1_at_news.mainstreet.net>, Peter Shvets <pshvets_at_powermarket.com> writes
>Hello, everybody.
>I have a pretty simple question.
>I have a Perl script to create and drop tablespaces.
>Before I drop them, do I need to bring tablespaces offline?
>And if I don't, how it affects my database?
>
>Thanks in advance.
>Peter.
>
>
 

-- 
Pete Finnigan