Re: removing a datafile

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 29 Oct 1999 06:32:28 GMT
Message-ID: <7vbf1s$p3d@gap.cco.caltech.edu>

Maybe that's the way it is - you cannot actually delete the datafile entry in the data dictionary. Delete a tablespace is possible, which means delete all the datafiles that constitute that tablespace. Deleting a datafile may not be "logically" possible, because a datafile is NOT an independent storage unit (i.e. a table may span across several datafiles within the same tablespace).

Xuequn Xu

gonagona_at_my-deja.com wrote:
: What is the best way to remove a datafile from a database? I know I
: need to take it offline, remove it physically, and take the database
: online. However, when I check v$datafile, it says the status of the
: file I deleted is RECOVER.

: Please help!
: Thanks alot!

: Sent via Deja.com http://www.deja.com/
: Before you buy.
Received on Fri Oct 29 1999 - 01:32:28 CDT