Re: Clearing the RBS datafile.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 27 Aug 2002 11:51:31 +0200
Message-ID: <irimmu0o4e9nhbssi5uol1tq7n62487c6g@4ax.com>

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
>============

Try it

You did implement recovery procedures, did you?

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 27 2002 - 04:51:31 CDT