Manipulating the SNAPSHOT LOG tablespace

From: Linda Hagedorn <Linda_at_pets.com>
Date: Thu, 29 Jun 2000 16:22:13 -0700
Message-Id: <10543.110853@fatcity.com>

Hello,

I am fixing a problem with snapshots which has caused my snapshotlog tablespace to extend beyond my preferences. I'd like to reduce it's space, and wanted to know if anyone had done this.

I plan to
1) catch up all the snapshots and purge if necessary the snapshotlog datafiles (snapshotlog.dbf and snapshotlog2.dbf), 2) alter database datafile '/oradata/PETS/data/snapshotlog2.dbf' offline drop ;
3) alter tablespace add datafile '/oradata/PETS/data/snapshotlog2.dbf' Storage specs.

Was anyone successful doing something like this?

Any information is appreciated.
Linda Hagedorn Received on Thu Jun 29 2000 - 18:22:13 CDT