Xref: alice comp.databases.oracle.server:20314
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!portc01.blue.aol.com!audrey03.news.aol.com!not-for-mail
From: markp28665@aol.com (MarkP28665)
Newsgroups: comp.databases.oracle.server
Subject: Re: Drop a data file from a tablespace
Lines: 15
Message-ID: <1998050521124800.RAA12960@ladder03.news.aol.com>
X-Admin: news@aol.com
Date: 05 May 1998 21:12:48 GMT
Organization: AOL http://www.aol.com
References: <6ins89$ddq$1@nnrp1.dejanews.com>

From: yren@epsilon.com  >>
I am trying to drop a data file from a tablespace. I used command "alter
database datafile file_name offline drop". The command ran fine, no error
message, but when I check system view v$datafile or dba_data_files. The data
file was still there. Has anybody done this  <<

Check the file status.  I believe it is 'invalid'.  Also unless 7.3 has had a
change made to it, once you drop a datafile from a tablespace the tablespace
will need recovery.  The last time we did this was with 7.1.6 so I haven't
reviewed the manuals for this recently, but I dought that this changed.
 
Mark Powell  -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own
advice -