English

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

Error Message

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

Cause

This error can occur while attempting to bring ArcSDE up for the first time after Oracle 8.1.5 has been recently installed. When Oracle 8.1.5 Server was installed, the initialization of the rollback segments in the init.ora file was left commented out after installation.

Solution or Workaround

Shut down the Oracle instance, uncomment the rollback_segments parameter in the Oracle instance's init.ora file and restart the Oracle instance.