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.
guess yous tablespace is in autoallocate extent mode, no ?
I recreated the tablespace with uniform size 4m clause.
After that rollbak segment creation succedeed.
you need to create one rbs in system tbs before you can successfully create any rbs in a locally managed tablespace.
i got the same error on an earlier ocasson.