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.