Oracle Version:-10.2.0.5.0
I have undo tablespace, but still getting below error.
ORA-01552: cannot use system rollback segment for non-system tablespace
Also find below output.
09:23:01 kalkulus_158 >select segment_name,status from dba_rollback_segs;
SEGMENT_NAME STATUS
------------------------------ --------
SYSTEM ONLINE
_SYSSMU16960$ ONLINE
_SYSSMU16961$ ONLINE
_SYSSMU16962$ ONLINE
_SYSSMU16963$ ONLINE
_SYSSMU16964$ ONLINE
_SYSSMU16965$ ONLINE
_SYSSMU16966$ ONLINE
_SYSSMU16967$ ONLINE
_SYSSMU16968$ ONLINE
_SYSSMU16969$ ONLINE
_SYSSMU16970$ ONLINE
_SYSSMU16971$ ONLINE
_SYSSMU16972$ ONLINE
_SYSSMU16973$ ONLINE
_SYSSMU16974$ ONLINE
_SYSSMU16975$ ONLINE
_SYSSMU16976$ OFFLINE
_SYSSMU16977$ OFFLINE
_SYSSMU16978$ OFFLINE
_SYSSMU16979$ OFFLINE
_SYSSMU16980$ OFFLINE
_SYSSMU16981$ OFFLINE
_SYSSMU16982$ OFFLINE
_SYSSMU16983$ OFFLINE
_SYSSMU16984$ OFFLINE
_SYSSMU16985$ OFFLINE
_SYSSMU16986$ OFFLINE
_SYSSMU16987$ OFFLINE
_SYSSMU16988$ OFFLINE
_SYSSMU16989$ OFFLINE
_SYSSMU16990$ OFFLINE
_SYSSMU16991$ OFFLINE
_SYSSMU16992$ OFFLINE
_SYSSMU16993$ OFFLINE
_SYSSMU16994$ OFFLINE
_SYSSMU16995$ OFFLINE
_SYSSMU16996$ OFFLINE
_SYSSMU16997$ OFFLINE
_SYSSMU16998$ OFFLINE
_SYSSMU16999$ OFFLINE
_SYSSMU17000$ OFFLINE
_SYSSMU17001$ OFFLINE
_SYSSMU17002$ OFFLINE
_SYSSMU17003$ OFFLINE
_SYSSMU17004$ OFFLINE
_SYSSMU17005$ OFFLINE
_SYSSMU17006$ OFFLINE
_SYSSMU17007$ OFFLINE
_SYSSMU17008$ OFFLINE
_SYSSMU17009$ OFFLINE
51 rows selected.