Re: changing rollbacks

1. Either you re-created the rollback segments with a different name and data file name., or remove the REUSE keyword and remove the data file for each rollback segment.
2. You should avoid at ALL COST, the practice of create any rollback seg. in the same tablspace that contained users data. or create any private rollback seg., unless there is a compelling reason to do so. Try to create a ROLLBACK tablespace and put all the rollback segs. in here. It'll improve your database performance since it avoid the contention with you data on the same tablespace.
3. If your database has a lot of small insert/update transactions then you probably needed 5 ~ 8 rollback segs with 0.5MB ~ 10 MB each ( depended on how wide your tables are). Or for a very large transaction, like IMP/EXP, created a large Rollback Segs (i.e... 100MB) for this task.

Good luck

Doug Cowles wrote in message <374EE970.1164527_at_bigfoot.com>...
>I could be just tired - but somthing's bugging me. I have three
>rollbacks,
>intitially sized at 70M on datafiles of 1.5 GB each. One tablespace per
>
>datafile, and one rollback segment for each tablespace. Nothing else in
>
>the tablespaces but their respective rollbacks.
>
>I wanted to change the intial size of the three rollbacks to 300M, and
>then
>shrink the datafiles to 600M. I dropped the three rollbacks, (which I
>thought
>would clear out the datafiles completely), and then recreated them with
>the new
>storage parameters. When I try to shrink the datafiles to 600M, it
>tells me
>, ORA-03297: file contains 641 blocks of data beyond the requested
>RESIZE value.
>
>Now, it's Friday, and I'm leaving this one, but instinct tells me if I
>re-create the
>tablespace, everything will be dandy.. but how can this happen? If I've
>dropped any
>segments that are in that tablespace, corresponding to a rollback
>segment whose
>high water mark never exceeded 300M, why would there be data or
>allocated extents
>floating around the 600M mark??
>
>Thanks in advance,
>Dc.
>
Received on Mon May 31 1999 - 11:00:11 CDT