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

TNS-00289: Navigator: Disabled Interchange

1 Answers  


RMAN-06138: controlfile not mounted - must specify AT clause with REPORT command

1 Answers  


ORA-13251: duplicate entry string in metadata table

1 Answers  


ORA-07614: $CHANGE_CLASS failed in retrieving the user's process label

1 Answers  


ORA-01544: cannot drop system rollback segment

1 Answers  






NID-00109: DBNAME string length number exceeds maximum length of number

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  


ORA-31028: Resource metadata length string exceeded maximum length string

1 Answers  


TNS-12556: TNS:no caller

1 Answers  


ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.

1 Answers  


ORA-15001: diskgroup "string" does not exist or is not mounted

1 Answers  


ORA-04065: not executed, altered or dropped string

1 Answers  


Categories