How to fix the Oracle error ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)?

In this post, you’ll learn more about the Oracle ErrorORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks) ?

You can fix this error in Oracle by following the below steps

Specify a larger OPTIMAL size.