Clearing the RBS datafile.

From: Nabil Courdy <moab88_at_emirates.net.ae>
Date: 27 Aug 2002 02:45:17 -0700
Message-ID: <ae1f8554.0208270145.673a2654@posting.google.com>

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

Received on Tue Aug 27 2002 - 04:45:17 CDT