The following is the ORA-01552 error message, you can learn the cause and solution of the Oralce error.


ORA-01552 cannot use system rollback segment for non-system tablespace ‘string

Cause: An attempt was made 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.

Solution: Create one or more private/public segment(s), shut down and restart. May need to modify the initialization parameter ROLLBACK_SEGMENTS to acquire private rollback segment. If this is a clone database being used for tablespace point in time recovery then this operation is not allowed.

Case:

Please wait for the update…