ORA-12913: Unable to create dictionary managed tablespace

Jcq0>Show user
User is "sys"
Jcq0>Create tablespace dictionary_t
2 datafile 'd:/Oracle/oradata/db_namex/dict. dbf' size 50 m
3Extent Management Dictionary
4 default storage (initial 100 K next 100 k );
Create tablespace dictionary_t
*
Error is located in row 1st:
ORA-12913: Unable to create dictionary managed tablespace

 

View error description

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.

This information tells us that you can use the preceding statement to create a dictionary-managed tablespace only when the system tablespace is dictionary-managed.

3. peak return

I suddenly thought that there was not a package that could be migrated between the tablespace managed locally and the tablespace managed in the dictionary. Then I found the package.

Dbms_space_admin.tablespace_migrate_from_local
Dbms_space_admin.tablespace_migrate_to_local

It seems that I can, so I will do it right away.

Jcq0>Execute dbms_space_admin.tablespace_migrate_from_local ('test10 ');
Begin dbms_space_admin.tablespace_migrate_from_local ('test10'); end;

*
Error is located in row 1st:
ORA-12914: Unable to port tablespace to dictionary-managed type
ORA-06512: In "SYS. dbms_space_admin", line 0
ORA-06512: In line 1

ORA-12914 cannot migrate tablespace to dictionary managed type

Cause: an attempt was made to migrate a locally managed tablespace to dictionary managed type when the database has a locally managed system tablespace.

Action: such an operation cannot be issued.

As prompted, migrate the system tablespace first.

Jcq0>Execute dbms_space_admin.tablespace_migrate_from_local ('system ');
Begin dbms_space_admin.tablespace_migrate_from_local ('system'); end;

*
Error is located in row 1st:
ORA-03251: unable to submit this command on system tablespace
ORA-06512: In "SYS. dbms_space_admin", line 0
ORA-06512: In line 1

ORA-03251 cannot issue this command on the system tablespace

Cause: it is not permitted to migrate system tablespace from locally managed format to dictionarymanaged format or relocate bitmaps.

Action: Check the tablespace name and procedure name.

4. Return to Origin

Go to the doc to explain the process and get the same explanation.

The tablespace must be kept online and read/write during migration. Migration of temporarytablespaces and migration of system tablespaces are not supported.

5. Conclusion

If you wantLocal tablespace ManagementOfDatabaseCreate a tablespace for dictionary management. The answer is no way !!!