I have ORacle8.1.7. I createad a locally managed tablespace. I want to create a rollback segment in the same tablespace.
It is giving the following error
SQL> CREATE PUBLIC ROLLBACK SEGMENT "largerbs"
2 TABLESPACE "EPRORBS" ;
CREATE PUBLIC ROLLBACK SEGMENT "largerbs"
ERROR at line 1:
ORA-25151: Rollback Segment cannot be created in this tablespace
Any ideas Why? It's obvious I am making a mistake, but I can't figure it out.