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

ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.

1 Answers  


NNL-00221: Statistic counter logging interval is now string

1 Answers  


PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and WHENEVER SQLWARNING used

1 Answers  


ORA-24074: RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string

1 Answers  


DRG-11875: Access Scheme Is Not Allowed

1 Answers  






ORA-09870: spini: failure initializing maximum number of open files.

1 Answers  


ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based

1 Answers  


NID-00425: Database name restored to string.

1 Answers  


ORA-16162: Cannot add new standby databases to protected configuration

1 Answers  


NNO-00634: received authoritative name "string" when we are its authority

1 Answers  


ORA-01545: rollback segment 'string' specified not available

1 Answers  


ORA-06731: TLI Driver: cannot alloc t_call

1 Answers  


Categories