topic Re: ORA 12913- Cannot create dictionary managed tablespace in Operating System - HP-UX

ORA 12913- Cannot create dictionary managed tablespace

Pinki Meggi — Tue, 07 Feb 2006 04:23:41 GMT

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

Re: ORA 12913- Cannot create dictionary managed tablespace

Sivakumar TS — Tue, 07 Feb 2006 04:26:36 GMT

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.

Re: ORA 12913- Cannot create dictionary managed tablespace

Sivakumar TS — Tue, 07 Feb 2006 04:28:21 GMT

Chk this link...

http://www.orafaq.com/forum/t/48360/0/

Re: ORA 12913- Cannot create dictionary managed tablespace

Arunvijai_4 — Tue, 07 Feb 2006 04:30:59 GMT

Hi Pinki,

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

-Arun

Re: ORA 12913- Cannot create dictionary managed tablespace

Arunvijai_4 — Tue, 07 Feb 2006 04:32:48 GMT

Also, check this out

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

-Arun

Re: ORA 12913- Cannot create dictionary managed tablespace

Sanjay Kumar Suri — Tue, 07 Feb 2006 04:34:03 GMT

What is your Oracle database version?

sks

Re: ORA 12913- Cannot create dictionary managed tablespace

Pinki Meggi — Tue, 07 Feb 2006 05:08:35 GMT

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

Re: ORA 12913- Cannot create dictionary managed tablespace

Simon Wickham_6 — Tue, 07 Feb 2006 05:22:08 GMT

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

Re: ORA 12913- Cannot create dictionary managed tablespace

Pinki Meggi — Tue, 07 Feb 2006 06:21:54 GMT

thanks all

Best Regards