ORA-12913: 無法創(chuàng)建字典管理的表空間

jcq0>show user
USER 為"SYS"
jcq0>create tablespace dictionary_t
  2  datafile 'D:\Oracle\ORADATA\DB_NAMEX\dict.dbf' size 50M
  3  extent management dictionary
  4  default storage(initial 100k next 100k);-
 

create tablespace dictionary_t
*
ERROR 位于第 1 行:
ORA-12913: 無法創(chuàng)建字典管理的表空間

查看錯(cuò)誤解釋

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.

該信息告訴我們只能在SYSTEM表空間為字典管理時(shí)才能用以上語句創(chuàng)建字典管理的表空間

3.峰回路轉(zhuǎn)

突然想到不是有個(gè)包可以在本地管理的表空間和字典管理的表空間之間遷移么,之后找到該包

DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL

看來果然可以,于是馬上動手

jcq0>execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('TEST10');
BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('TEST10'); END;

*
ERROR 位于第 1 行:
ORA-12914: 無法將表空間移植到字典管理的類型中
ORA-06512: 在"SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: 在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.

同樣的提示,所以先遷移SYSTEM表空間

jcq0>execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM');
BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM'); END;

*
ERROR 位于第 1 行:
ORA-03251: 無法在 SYSTEM 表空間上提交此命令
ORA-06512: 在"SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: 在line 1

ORA-03251 Cannot issue this command on 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.回到原點(diǎn)

翻到doc對該過程的說明可以得到同樣的解釋

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

5.結(jié)論

 如果你想在SYSTEM為本地管理表空間的數(shù)據(jù)庫上建立字典管理的表空間,那么答案是 no way!!!

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]