Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop tablespace
Well, maybe, ...
If your tablespaces have anything in them, the 'drop tablespace' command will fail unless you use the 'including contents'
and, if needed, 'cascade constraints' option..
It certainly will affect your database, since anything in that tablespace will be lost and if you mess up and specify
'system' for instance, your database goes bye-bye..
If the tablespace is empty and not the system one, you can create and drop at will.. ( Note : the datafiles associated with the tablespace are not deleted by that command...Your OS has to do that..)
"Winner Manurung" <manruw_at_uninet.net.id> wrote:
>Please read inserted comments.
>
>Regards,
>Winner
>
>Peter Shvets <pshvets_at_powermarket.com> wrote in message
>news:9kfl08$up2$1_at_news.mainstreet.net...
>> 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?
>No.
>
>> And if I don't, how it affects my database?
>No effect.
>
>>
>> Thanks in advance.
>> Peter.
>>
>>
>
>
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Aug 07 2001 - 09:52:54 CDT