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

NZE-29157: Unable to build an absolute path to the library.

1 Answers  


ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists

1 Answers  


ORA-06007: NETASY: bad dialogue format

1 Answers  


PCB-00110: Unable to open temporary file "string"

1 Answers  


ORA-38483: invalid FUNCTION/PACKAGE/TYPE name: "string"

1 Answers  






PLS-00461: mismatch REPEATABLE information between specification and body of 'string'

1 Answers  


SQL*Loader-00402: Unable to determine length of column string from specification

1 Answers  


RMAN-12017: could not locate pieces of backupset key string

1 Answers  


TNS-00289: Navigator: Disabled Interchange

1 Answers  


ORA-30120: 'string' is not a legal oracle number for 'string'

1 Answers  


ORA-25212: invalid PRIORITY specified when using sequence deviation

1 Answers  


ORA-13852: Tracing for service(module/action) string is not enabled

1 Answers  


Categories