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

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

Question Posted / guest

1 Answers
3215 Views
I also Faced
E-Mail Answers

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-00299: must use file-level media recovery on data file string

1 Answers

ORA-31497: invalid value specified for first_scn

1 Answers

DRG-50942: errors: stringstring

1 Answers

RMAN-06122: CHANGE .. UNCATALOG not supported for BACKUPSET

1 Answers

SQL*Loader-00423: element count is greater than maximum allowed for the column

1 Answers

ORA-00723: Initialization parameter COMPATIBLE must be explicitly set

1 Answers

RMAN-04000: memory allocation failure

1 Answers

ORA-00314: log string of thread string, expected sequence# string doesn't match string

1 Answers

ORA-00051: timeout occurred while waiting for a resource

1 Answers

ORA-24412: Cannot reinitialize non-existent pool

1 Answers

ORA-00030: User session ID does not exist.

1 Answers

PLS-01411: Use of 'REM' token

1 Answers

For more Oracle Errors Interview Questions Click Here