[oracle@lonion ~]$ oerr ora 01536 【案例出现在Oracle11g】
ORA-01536: space quota exceeded for tablespace 'string'
// *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.
出现的原因可能：使用REVOKE UNLIMITED TABLESPACE命令后，导致设置的用户QUOTA也消失了。
解决方法：
对用户重新设置QUOTA。
如何避免此错误：
先REVOKE用户的UNLIMITED TABLESPACE，再设置用户的QUOTA。
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24389441/viewspace-1056418/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- 物理standby取消应用日志，出现ORA-16136
- Oracle开发：变量不可VN1<VN2<VN3?
- ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
- Tablespace Point-in-time Recovery (TSPITR) using RMAN
- SESSION连接数
- Red Hat Linux：Linux下访问windows XP的共享文件夹
- MS SQL Server:从该备份集进行读取时，RESTORE检测到在数据库.......
- Opening the Database with the RESETLOGS Option
- Oracle备份与恢复：Types of Oracle Recovery
- Oracle工具DBVERIFY: Offline Database Verification Utility
