Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problems with dropping datafile in tablespace

Problems with dropping datafile in tablespace

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Thu, 01 May 2003 10:19:51 GMT
Message-ID: <p7t1bv8nmj8isu16h4ucojrdm66pfecdl9@4ax.com>


After I did the following:

alter database datafile 'c:\oracle\oradata\db\tools\T1.dbf' offline drop;

select file_name, tablespace_name from dba_data_files;

The datafile that I dropped was still shown as part of the tablespace. Why is that? Received on Thu May 01 2003 - 05:19:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US