Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Drop datafile
Hi,
is it possible to drop a non-used datafile from a tablespace? I tried with alter database offline drop, but the file is still in dba_data_files. If I remove the physical file, Oracle complains.
Thanks I'll appreciate an email to dani_at_cesca.es
--Received on Fri Jan 02 1998 - 00:00:00 CST
-----------------------------------------------------------------------
Daniel PiƱol Scientific Promotion CESCA - Centre de Supercomputacio de Catalunya Edifici Nexus Phone: (34)(3) 2056464 Gran Capita, 2-4 Fax: (34)(3) 2056979 08034 Barcelona, SPAIN e-mail: dpinol_at_cesca.es
-----------------------------------------------------------------------
![]() |
![]() |