朋友生产数据库在向特定的一张表插入数据时报超出表空间data的空间限额如是执行下查看用户所用的表空间配额信息，查看用户所使用表空间的配额发现没有限制,因为max_bytes为 -1

SQL>select*fromdba_ts_quotaswhereusername='data';TABLESPACE_NAMEUSERNAMEBYTESMAX_BYTESBLOCKSMAX_BLOCKSDROPPED-----------------------------------------------------------------------------------------------------------datadata8825732464-1107735992-1NO1rowsselectedSQL>SQL>select2fs.tablespace_name"Tablespace",3(df.totalspace-fs.freespace)"UsedMB",4fs.freespace"FreeMB",5df.totalspace"TotalMB",6round(100*(fs.freespace/df.totalspace))"Pct.Free"7from8(selecttablespace_name,round(sum(bytes)/1024/1024)TotalSpace9fromdba_data_filesgroupbytablespace_name)df,10(selecttablespace_name,round(sum(bytes)/1024/1024)FreeSpace11fromdba_free_spacegroupbytablespace_name)fs12wheredf.tablespace_name=fs.tablespace_name;TablespaceUsedMBFreeMBTotalMBPct.Free----------------------------------------------------------------------SYSTEM720730331024030TEST6790341704096083USERS173254272560099UNDOTBS2227240132424099DATA990119176281116640015SYSAUX39251195512023UNDOTBS1128982806240960697rowsselected

查看表lv_data的依赖对象

SQL>selectNAME,TYPEfromdba_dependencieswhereREFERENCED_NAME='LV_DATA';NAMETYPE------------------------------------------------LV_DATAVIEWFC_UPDATE_CORPFUNDPROCEDUREFC_UPDATE_MYPROCEDUREFC_UPDATE_KYPROCEDUREFC_UPDATE_FACTPAYPROCEDUREFC_UPDATE_CALCPAYPROCEDUREFC_UPDATE_KYPROCEDURE......LV_DATASYNONYMLV_DATAVIEWLV_DATASYNONYMLV_DATASYNONYM139rowsselected

查看所有依赖对象的所有者

SQL>selectdistinctownerfromdba_objectswhereOBJECT_NAMEin(selectNAMEfromdba_dependencieswhereREFERENCED_NAME='LV_DATA');OWNER------------------------------SYSY_BKWEBCXDATAOLDTESTXCCZOSYBACKUPTJ12rowsselected

对所有依赖对象所有者授权可以无限制使用表空间

SQL>grantunlimitedtablespacetoOSY;GrantsucceededSQL>grantunlimitedtablespacetoSBK;GrantsucceededSQL>grantunlimitedtablespacetoWEB;GrantsucceededSQL>grantunlimitedtablespacetoCX;GrantsucceededSQL>grantunlimitedtablespacetoDATA;GrantsucceededSQL>grantunlimitedtablespacetoOLD;GrantsucceededSQL>grantunlimitedtablespacetoTEST;GrantsucceededSQL>grantunlimitedtablespacetoXC;GrantsucceededSQL>grantunlimitedtablespacetoCZ;GrantsucceededSQL>grantunlimitedtablespacetoSY;GrantsucceededSQL>grantunlimitedtablespacetoBACKUP;GrantsucceededSQL>grantunlimitedtablespacetoTJ;Grantsucceeded

再向表lv_data插入数据时恢复正常