Re: Clearing the RBS datafile.

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 27 Aug 2002 18:27:55 GMT
Message-ID: <3d6bc439.1571859885@news.globix.com>

Craete a rollback segment in a different tablespace Online it
Offline all RBSs in this tablespace
drop them
drop the tablespace
create tablespace w/ new datafile size
create new/old RBSs w/ your 'optimal' clause in this tablespace online them
If your transactions are short, you should be able to do this in 10mins or less

On 27 Aug 2002 02:45:17 -0700, moab88_at_emirates.net.ae (Nabil Courdy) wrote:

>Oracle 8.1.5 on Tru64 UNIX
>
>When taking a cold backup, the zipped size of the rollback segemet
>tablespace datafile is about 186MB. The unzipped version's size is
>600MB. Enterprise Manager shows that only 26MB (4%) is utilized. I
>have shrunk all RBS to their optimal value. It is clear that junk
>bytes are left in the datafile and they are getting compressed. Can I
>clear this file completely without having to create a new RBS
>tablespace with a new datafile.
>
>Nabil Courdy
>============

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Aug 27 2002 - 13:27:55 CDT