Re: How to drop a datafile that has been offline?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 1 Feb 2003 03:49:42 +1100
Message-ID: <iGx_9.37570$jM5.95372@newsfeeds.bigpond.com>

Short answer: no. Once a file is part of a tablespace, it's there for ever. You can do things like 'alter database datafile blah offline drop', but that doesn't actually get rid of it, and it remains part of the tablespace and database structure.

Since you have 8i, however, it's not the end of the world. I know you didn't want to do it, but it's easiest simply to create a new tablespace with all the right characteristics, do a select segment_name from dba_segments where tablespace_name='YOUR_ORIGINAL_TABLESPACE_NAME', and use that as a list of segments to be moved to the new tablespace (alter table blah move tablespace newone, or alter index blah rebuild tablespace newone).

Then you send 'one of your DBAs' on proper training!

Regards
HJR "Rhugga" <root_NO_BLEEPING_SPAM_at_syrrx.com> wrote in message news:3E3A8D0C.2030909_at_syrrx.com...
>
> One of our DBA's created a new tablespace and changed the name of a
> datafile or something to that affect, anyway,the tablespace is online
> but one of it's datafiles has been offline and needs to be deleted.
>
> Is there a way to remove this datafile w/o having to rebuild the
> tablespace? We are running 8.1.7.4 on Solaris 8 64-bit.
>
>
> Thx,
> CC
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Fri Jan 31 2003 - 10:49:42 CST