Products | Versions |
---|---|
Not Applicable | - |
Resolution:
Regarding the specific error on rollback segment, it appears you will have to configure the ROLLBACK_SEGMENTS parameter for your instance.
Specifically, the Oracle documentation recommends the following action:
"Create one or more rollback segments and then use ALTER ROLLBACK
SEGMENT 'name' online. It may be necessary to modify the initialization parameter ROLLBACK_SEGMENTS to acquire one of the new private rollback segments. Before creating a rollback segment outside the SYSTEM tablespace, it is necessary to first create and activate a non-system rollback segment in the SYSTEM tablespace."