今天碰到一个错误:
ORA-01536: 超出表空间 'INXTSP11' 的空间限额
开始没看清,以为是表空间不够呢,就增加了一个表空间文件。
第二次发现还不对,于是查了查文档
[oracle@localhost oracle]$ oerr ora 1536
01536, 00000, "space quota exceeded for tablespace '%s'"
// *Cause: The space quota for the segment owner in the tablespace has
// been exhausted and the operation attempted the creation of a
// new segment extent in the tablespace.
// *Action: Either drop unnecessary objects in the tablespace to reclaim
// space or have a privileged user increase the quota on this
// tablespace for the segment owner.
发现解决方法如下:
alter user odomain01 quota unlimited on inxtsp11;
这时再重建索引就可以了。
[@more@]来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/41451/viewspace-1029119/ ,如需转载,请注明出处,否则将追究法律责任。