11.2.0.2版本修改回收UNLIMITED TABLESPACE功能

在11.2.0.2的環境中，碰到了這個問題，使用REVOKE UNLIMITED TABLESPACE命令後，發現設定的使用者QUOTA也消失了。

這是一個實際的案例，在客戶的環境中新建了一個使用者，準備匯入一些資料，結果碰到了問題：

SQL> create user thams account unlock identified by thams default tablespace LOB_AU2M quota unlimited on LOB_AU2M;

User created.

SQL> grant connect,resource to thams;

Grant succeeded.

SQL> grant create view,create synonym,create database link to thams;

Grant succeeded.

SQL> revoke unlimited tablespace from thams;

Revoke succeeded.

SQL> grant read,write on directory expdir to thams;

Grant succeeded.

SQL> exitITPUB個人空間 eh:ewn}h
Disconnected from Database Enterprise Edition Release 11.2.0.2.0 - 64bit Production
'[#`;MaG196700With the Partitioning, Automatic Storage Management, OLAP, Mining
3ucxyk'p:mAm{196700and Real Application Testing optionsITPUB個人空間{W2z/D+pd.ivT?
[oracle@dbserver1 oracle-export]$ impdp thams/thams dumpfile=AMS-ORA9_20110815_2.DP logfile=AMS-ORA9_20110815_2_imp.log directory=expdir remap_tablespace=THAMS:LOB_AU2M remap_tablespace=users:lob_au2m

Import: Release 11.2.0.2.0 - Production on Tue Aug 16 12:36:41 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit ProductionITPUB個人空間,Al:VHs[v4E
With the Partitioning, Automatic Storage Management, OLAP, Data MiningITPUB個人空間$C:cl0H*W(qB
and Real Application Testing optionsITPUB個人空間'?3G)z'B6X,u)pC8TTL
ORA-39006: internal error
K4d S;m#WC196700ORA-39068: invalid master data in row with PROCESS_ORDER=-4
#`-}l)CK,n9q196700ORA-01536: space quota exceeded for tablespace 'LOB_AU2M'

ORA-39097: Data Pump job encountered unexpected error -1536

剛看到這個錯誤的時候十分疑惑，明明在建立使用者的時候指定了LOB_AU2M表空間上的無限制的QUOTA，怎會仍然會出現這個錯誤呢。

但是檢查，確實沒有發現無限QUOTA的存在：

[oracle@dbserver1 oracle-export]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Aug 16 12:38:29 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:ITPUB個人空間hsk2r~x E"TG
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
E?!mNh8x196700With the Partitioning, Automatic Storage Management, OLAP, Data Mining
n-K0FQrhO0M7[1d ia%M196700and Real Application Testing options

SQL> set pages 100 lines 120
0qN,YmP-O}b