be carreful ! for the second solution, it doesn't seem to be eficient under
NT !...
satar_at_my-dejanews.com a écrit dans le message
<72htju$il8$1_at_nnrp1.dejanews.com>...
>No, you have 2 options:
>
>1) rebuild the RBS tablespace
>2) 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 Sat Nov 14 1998 - 19:48:58 CST
