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

Home -> Community -> Usenet -> c.d.o.server -> Drop datafile

Drop datafile

From: Daniel Pinol <dpinol_at_cesca.es>
Date: 1998/01/02
Message-ID: <34AD2833.5D62B814@cesca.es>#1/1

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
-- 

-----------------------------------------------------------------------
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
-----------------------------------------------------------------------
Received on Fri Jan 02 1998 - 00:00:00 CST

Original text of this message

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