Monthly Archives: May 2011

ORA-12913: Cannot create dictionary managed tablespace

Problem: While creating a dictionary managed tablespace in Oracle 9i, the following error appears:

SQL> r
 1  CREATE TABLESPACE data01
 2  DATAFILE '$HOME/oradata/ORCL/data01.dbf' SIZE 2M
 3* EXTENT MANAGEMENT DICTIONARY
 CREATE TABLESPACE data01
 *
 ERROR at line 1:
 ORA-12913: Cannot create dictionary managed tablespace
 Solution:

Consulting the Oracle 9i online documentation, the following cause and action is found:

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.

As a result, the dictionary managed tablespace cannot be created in this Oracle 9i database.

Reference:

http://download.oracle.com/docs/cd/B10500_01/server.920/a96525/e12700.htm