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 (s..

Answer / guest

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

Action: Specify a larger OPTIMAL size.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06057: a standby controlfile cannot be included along with a current controlfile

1 Answers  


ORA-39027: wrong version of master table

1 Answers  


NID-00436: Modify parameter file and generate a new password file before restarting.

1 Answers  


ORA-31617: unable to open dump file "string" for write

1 Answers  


NID-00131: Control file is not current

1 Answers  


LSX-00242: bad Boolean "~S"

1 Answers  


EXP-00030: Unexpected End-Of-File encountered while reading input

1 Answers  


LFI-00136: Unable to change type of open file.

1 Answers  


ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

1 Answers  


ORA-29913: error in executing string callout

1 Answers  


ORA-27033: failed to obtain file size limit

1 Answers  


ORA-01090: shutdown in progress - connection is not permitted

1 Answers  


Categories