Is This Content Helpful?
We're glad to know this article was helpful.
How can we make this better? Please provide as much detail as possible.
Contact our Support Team
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.
Last Published: 5/5/2016
Article ID: 000002316
Software: ArcSDE 8.0.2, 8.0.1, 3.0.2.2