I get the following error message: ORA-01552: cannot use system rollback segment for non-system tablespace 'ODS'ORA-06512: at "ODS_DEVELOP.C$TIBCORV1BADMIN", line 173ORA-06512: at line 7
Article ID: KB0092124
Updated On:
| Products | Versions |
|---|---|
| Not Applicable | - |
Description
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."
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."
Issue/Introduction
I get the following error message:
ORA-01552: cannot use system rollback segment for non-system tablespace 'ODS'ORA-06512: at "ODS_DEVELOP.C$TIBCORV1BADMIN", line 173ORA-06512: at line 7
Environment
Product: TIBCO Adapter for Oracle AQ
Version: All
OS: Not Specified OS
--------------------
Feedback
Yes
No
Powered by
