-
Hi! All
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.
ajay