Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT ..Remove datafile from tablespace
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