Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problems with dropping datafile in tablespace
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:17:52 CDT
![]() |
![]() |