Re: Drop a data file from a tablespace

From: yren_at_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 - Received on Tue May 05 1998 - 16:12:48 CDT