ora-1552

Hi all,
What do i need to fix the below issue and what's causing ..
Pls advise. Thank you


ora-1552 cannot use system rollback segment for non-system tablespace.

Currently you have only SYSTEM rollback segment available. Either all other rollback segments of yours are offline or they were not created yet.

You need to create and put online at least one more rollback segment to avoid that error.

You need to create some more rollback segments and place them online.

http://download-east.oracle.com/docs...21_res.htm#562

Create at least one rollback segment apart from system rollback segment and make it online.(Put entry in initSID.ora also)
Sandy