Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA 12913- Cannot create dictionary managed tablespace

SOLVED
Go to solution
Pinki Meggi
Frequent Advisor

ORA 12913- Cannot create dictionary managed tablespace

Hi all,
im having the following error when trying to create a tablespace:
CREATE TABLESPACE USERS BLOCKSIZE 8192 DATAFILE 'u1/oradata/siges/users01.dbf'SIZE 127803392 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M, 'u1/oradata/siges/users02.ora SIZE 20972520 EXTENT MANAGEMENT DICTIONARY DEFAULT NOCOMPRESS STORAGE (INITIAL 516096 NEXT 516096 MINEXTENTS 1 MAXEXTENTS 250 PCTINCREASE 0) ONLINE PERMANENT NOLOGGING;


ORA-12913: Cannot create dictionary managed tablespace


Can anyone help me to solve this problem?


Best Regards

Pinki
8 REPLIES
Sivakumar TS
Honored Contributor

Re: ORA 12913- Cannot create dictionary managed tablespace



Dear Pinki,

Check this info from Oracle,

ORA-12913: Cannot create dictionary managed tablespace

Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

Action: Create a locally managed tablespace.


Hope this helps,

Siva.


Nothing is Impossible !
Sivakumar TS
Honored Contributor

Re: ORA 12913- Cannot create dictionary managed tablespace

Chk this link...

http://www.orafaq.com/forum/t/48360/0/
Nothing is Impossible !
Arunvijai_4
Honored Contributor

Re: ORA 12913- Cannot create dictionary managed tablespace

Hi Pinki,

http://ora-12913.ora-code.com/

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Arunvijai_4
Honored Contributor

Re: ORA 12913- Cannot create dictionary managed tablespace

Also, check this out

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6690299776039

-Arun
"A ship in the harbor is safe, but that is not what ships are built for"
Sanjay Kumar Suri
Honored Contributor

Re: ORA 12913- Cannot create dictionary managed tablespace

What is your Oracle database version?

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Pinki Meggi
Frequent Advisor

Re: ORA 12913- Cannot create dictionary managed tablespace

Hi,

thanks for your attention


The Oracle version is 9i.

About the links, i have checked out them, and tried to find if the system tablespace is locally managed or not, and obtain the followng output:


select * from dba_tablespaces where tablespace_name='SYSTEM';

Tablespace_name= SYSTEM
Block_size=8192
initial_extent=65536
next_extent=
min_extents=1
max_extents=2147483645
pct_increase=
min_extlen=65536
status=online
contents=permanent
logging=logging
force_logging=no
extent_logging=local
allocation_type=system
plugged_in=no
segment_space_managemnet=manual

Im new at this platform, but it seem to be locally managed

So the solution is create locally tablespace?


CREATE TABLESPACE USERS BLOCKSIZE 8192 DATAFILE 'u1/oradata/siges/users01.dbf'SIZE 127803392 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M, 'u1/oradata/siges/users02.ora SIZE 20972520 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M, ONLINE PERMANENT NOLOGGING;

Best Regards

Pinki
Simon Wickham_6
Regular Advisor
Solution

Re: ORA 12913- Cannot create dictionary managed tablespace

Hi,

An error display 'ORA-12913' is caused when you have tried to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally manage. You can resolve this by creating a locally managed tablespace.

Example
-----------
CREATE TABLESPACE xxxx1
DATAFILE '/u01/oracle/data/xxxx01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

Regards,
Simon
Pinki Meggi
Frequent Advisor

Re: ORA 12913- Cannot create dictionary managed tablespace

thanks all

Best Regards