| tablespace, rollback segment error help me!!! [message #2012] |
Sun, 16 June 2002 23:20  |
genie3
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
i am korea, i don't well english...sorry.... please help me...
windows 2000 server / oracle 9i ... env
under statment run....
------------------------------------------------------
CREATE TABLESPACE rbs LOGGING
DATAFILE 'c:oracleoradatagenieRBS01.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT DICTIONARY;
ORA-12913:
---------------------------------------------------
if ---- EXTENT MANAGEMENT LOCAL; ------ sucussful...
---------------------------------------------------
SQL> create rollback segment rbs1
2 tablespace RBS
3 storage (initial 8K next 8K optimal 5M);
create rollback segment rbs1
ORA-01552:
TABLESPACE_NAME BLOCK_SIZE
------------------------------------------------------------ ----------
INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN
-------------- ----------- ----------- ----------- ------------ ----------
STATUS CONTENTS LOGGING FORCE_
------------------ ------------------ ------------------ ------
EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGE SEGMENT_SPAC
-------------------- ------------------ ------ ------------
XDB 8192
65536 1 2147483645 65536
ONLINE PERMANENT LOGGING NO
LOCAL SYSTEM NO AUTO
|
|
|
|
| Re: tablespace, rollback segment error help me!!! [message #2014 is a reply to message #2012] |
Sun, 16 June 2002 23:53  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
i believe,
ora-12913 is arising when you are trying to create a dictionary managed tablespaces (DMT) becuase
your database has system tablespace that
is locally managed (LMT).
with a SYSTEM as LMT you cannot create a DMT.
so create the tablespace RBS as LMT.
then try to create the Rollback Segments.
regards~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
