Oracle DBA, How To, Error, Cause and Action

ORA-01593: rollback segment optimal size (string blks) is smaller thanthe 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.