Showing posts with label ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks). Show all posts
Showing posts with label ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks). Show all posts

Tuesday, 17 January 2012

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

Cause: Specified OPTIMAL size is smaller than the cumulative size of the initial extents during create rollback segment.

Action: Specify a larger OPTIMAL size.