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

From: <satar_at_my-dejanews.com>
Date: Fri, 13 Nov 1998 18:26:06 GMT
Message-ID: <72htju$il8$1@nnrp1.dejanews.com>

No, you have 2 options:

rebuild the RBS tablespace
If you are running 7.2 or greater, you can shrink the size of the datafile.

Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
In article <364BD2E2.3E96686D_at_i-wave.net>,

John Koo <johnkoo_at_i-wave.net> wrote:
> Hi all,
>
> I have added a very large datafile to an existing RBS tablespace for
> a large query process. It there any way to remove this datafile from the
> RBS tablespace after use ?? Please advice...
>
> Thanks very much .
>
> John Koo
>
> johnkoo_at_i-wave.net
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 12:26:06 CST