Re: Is it possible to remove temporary added datafile from tablespace ?

You can issue SQL command to drop/take offline to any datafile you want, then physical delete the file, weather archive or non-archive mode, as long as not in the SYSTEM tablespace. Actually, if you tried to do that to the system tablespace, Oracle will not allow you to do so.

Never physically using RM in operating system to delete datafile without doing the SQL command first! Very dangerous, especially if you did it to the datafile belonging to the system tablespace. Doing that to a non-archive system without recent physical backup is equal to suicide.

Regarding the datafile belonging to the tablespace for Rollback Segment, I think that is the easiest part, since no data is needed. The only point to notice is that Oracle will not let you take an datafile offline if it contains active rollback segment (uncommited transaction) and will wait until all the related transactions are commited or rolled back. Never do this during working hour when long-running query is going on, since it may result in 'Snapshot too old' error message!

satar_at_my-dejanews.com wrote in message <72v9rk$lfq$1_at_nnrp1.dejanews.com>...
>John, Congrats! Was it done by creating another RBS tablespace with
rollback
>segments and dropping the old RBS tablespace and rollback segments? or did
u
>do something else, and if so...please tell us.
>
>Satar
>
>In article <3652A728.F3F3C743_at_i-wave.net>,
> John Koo <johnkoo_at_i-wave.net> wrote:
>> I 've actually rebuilt my rbs tablespace again ! It is not that
troublesome
>> ! and I could finish it in a short time !
>>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 24 1998 - 19:02:46 CST