ORA-01552: cannot use system rollback segment for non-system tablespace ''

The following video provides you with the correct English pronunciation of the word "ORA-01552", to help you become a better English speaker.

cannot use system rollback segment for non-system tablespace "name"

---

Section: 01500-01699 Oracle Commands Messages
Notes: This section lists messages generated when entering Oracle commands.If you are using Trusted Oracle, see the Trusted Oracle documentation for information about error messages in that environment.

---

Cause: An attempt was made to use the SYSTEM rollback segment for operations involving a non-system tablespace.

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.

---

Provided by PB for Oracle Professional.

01552, 00000, "cannot use system rollback segment for non-system tablespace '%s'"
*Cause: Tried to use the system rollback segment for operations involving
non-system tablespace. If this is a clone database then this will
happen when attempting any data modification outside of the system
tablespace. Only the system rollback segment can be online in a
clone database.
*Action: Create one or more private/public segment(s), shutdown and then
startup again. May need to modify the INIT.ORA parameter
rollback_segments to acquire private rollback segment. If this is
a clone database being used for tablspace point in time recovery
then this operation is not allowed.