Re: Rollback Segment Tablespace Datafile resized

You got this message because the average of your rollback segment's optimal size is greater than 40M spread across all your datafiles. Also, if you shorten the size of your RBS Tablespace, when your rollback segments want to allocate an extent, they may not have room. Anyway, to solve your problem... alter the size to 50M, if that doesn't work...try 60M, and so forth.

Good Luck,
Satar

In article <362F3DFB.187B_at_openix.com>,
  tansel_at_openix.com wrote:
> Hello all,
>
> I realized that my rollback segmengt tablespace is bigger
> than necessary and I wanted to resize its datafile to a smaller
> size, from 120 M to 40M. Even though there are no active
> transactions against the database, I got the following
> error message:
>
> ORA-03297: File contains 1545 blocks of data beyond requested
> RESIZE value.
>
> Any suggestions,
>
> 10X,
>
> Tansel
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own