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

From: Ian Evans <eon_at_mira.net>
Date: 27 Nov 1998 01:38:18 GMT
Message-ID: <01be19a6$40c57320$032811cb@eon.nmh-au>

Regarding putting rollback segs offline - Yes....don't have it pending offline, waiting for the DML to finish, because if the DML has to allocate another RBS extent, it will not be able to and will also fail.

regards, Ian Evans

>
> 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!
>
Received on Thu Nov 26 1998 - 19:38:18 CST