-
Hi all ,
I m trying to create a table space in new database and then after creating table space i m trying to create rollback segment but all the time i get this error
ORA-25151: Rollback Segment cannot be created in this tablespace
please solve my problem i m using following code to create table space and rollback segment in oracle 9i
#set echo on
#define ORA_HOME = "C:\Oracle\Ora90"
#define CVC_HOME = "C:\Oracle\ORADATA\CVC"
create tablespace CVC_RBS
datafile '&CVC_HOME\CVC_DBS_01.DBF' SIZE 100M
default storage ( initial 1024K
next 1024K
minextents 1
maxextents 1000
pctincrease 1);
create rollback segment RB0
tablespace CVC_RBS
storage
(
initial 512K
next 512K
minextents 20
maxextents 1000
);
alter rollback segment RB0 online;
-
it should work fine. which platform do u use
Santosh Jadhav
8i OCP DBA
-
Could you post the result of this query:
SELECT TABLESPACE_NAME, EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM DBA_TABLESPACES;
-
in 8i you cannot create RBS in LMT without creating previously a dummy one in dictionary but I am not sure if this is true in 9i though but you may have a look into that
-
Originally posted by aarroyob
Could you post the result of this query:
SELECT TABLESPACE_NAME, EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM DBA_TABLESPACES;
TABLESPACE_NAME EXTENT_MAN ALLOCATIO
------------------------------ ---------- ---------
SYSTEM DICTIONARY USER
UNDOTBS LOCAL SYSTEM
CWMLITE LOCAL SYSTEM
DRSYS LOCAL SYSTEM
EXAMPLE LOCAL SYSTEM
INDX LOCAL SYSTEM
TEMP LOCAL UNIFORM
TOOLS LOCAL SYSTEM
USERS LOCAL SYSTEM
CVC_DATA LOCAL SYSTEM
CVC_INDEX LOCAL SYSTEM
TABLESPACE_NAME EXTENT_MAN ALLOCATIO
------------------------------ ---------- ---------
CVC_RBS LOCAL SYSTEM
CVC_TEMP LOCAL SYSTEM
CVC_USER LOCAL SYSTEM
-
Hi see what error says..
dbserv% oerr ora 25151
25151, 00000, "Rollback Segment cannot be created in this tablespace"
// *Cause: An attempt was made to create a rollback segment in a tablespace
// with autoallocate extent allocation policy.
// *Action: Specify a different tablespace for the rollback segment
Thanks.
Thanigaivasan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|