Operating System - HP-UX
1748073 Members
4587 Online
108758 Solutions
New Discussion юеВ

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 8
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