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 -> Re: URGENT ..Remove datafile from tablespace

Re: URGENT ..Remove datafile from tablespace

From: tmgn <tmgn_at_excite.com>
Date: Mon, 09 Aug 1999 13:50:55 -0400
Message-ID: <37AF14FE.9866B0AF@excite.com>


Even if you Remove the Empty Datafile from your Tablespace and drop that file at the Os level, Dba_data_files or v$Datafile would still show the Datafile as part of the Tablespace(with STATUS=needs Recovery or INvalid) unless you Recreate the Tablespace ..

-Thiru

Agi wrote:

> Hi,theres,
> My db is 8.0.5 on IBM SP2 (OPS 2 nodes using row device).
> Is it possible to remove a datafile(file system) from tablespace ???
> Is drop/recreate tablespace the only one way ????
>
> Rgds,
> Agi
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 09 1999 - 12:50:55 CDT

Original text of this message

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