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-06720: TLI Driver: SID lookup failure

1 Answers  


ORA-07484: snlkput: cannot convert(put) lock.

1 Answers  


ORA-02211: invalid value for PCTFREE or PCTUSED

1 Answers  


ORA-22862: specified object identifier doesn't match existing object identifier

1 Answers  


UDI-00007: attempt to free unallocated memory

1 Answers  


ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.

1 Answers  


ORA-30014: operation only supported in Automatic Undo Management mode

1 Answers  


ORA-23403: refresh group "string"."string" already exists

1 Answers  


NNL-01041: Data stream open failures: number

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


DRG-11868: Too Many Redirections

1 Answers  


AMD-00101: cannot create string "string"; metadata entity already exists

1 Answers  


Categories