ORA-1536: space quota exceeded for tablespace "<name>"
来源:互联网 发布:淘宝联盟的客服电话 编辑:程序博客网 时间:2024/04/30 05:40
Error: ORA 1536
Text: space quota exceeded for tablespace "<name>"
-------------------------------------------------------------------------------
Cause: The space quota in the tablespace is already used up and the operation
attempted the creation of a new extent in the tablespace.
Action: Either
Drop unnecessary objects in the tablespace to reclaim space.
Ask the database administrator to increase the tablespace quota.
该错误的处理方式:
The DBA must grant additional resource quota on the tablespace to that user.
One or all of the following may fix the problem:
1) Increase the tablespace quota allocated to that user by using the following command:
ALTER USER <user_name> QUOTA <integer> [K/M] ON <tablespace_name>
2) Grant unlimited quota to the user on that tablespace by using the following command:
ALTER USER <user_name> QUOTA UNLIMITED ON <tablespace_name>
If the problem occurs even after executing the above steps, then run the following command:
GRANT RESOURCE TO <user_name>
这个错误主要是由于表空间不足造成的,解决方法就是添加表空间大小
一般我喜欢这个解决方法:grant unlimited tablespace to username
unlimited tablespace 权限在移除dba权限时会被一起移除
- ORA-1536: space quota exceeded for tablespace "<name>"
- ORA-01536: space quota exceeded for tablespace
- ORA-01536: space quota exceeded for tablespace
- 遇到错误 ORA-01536: space quota exceeded for tablespace 'XXX'
- ORA-01536: space quota exceeded for tablespace 'JIRA' ))
- oracle ORA-01536: space quota exceeded for tablespace 'USERS'
- ora-01536:space quota exceeded for tablespace 'users'
- ORA-01950: no privileges on tablespace ,ORA-01536: space quota exceeded for table space 'CYYD'
- ORA-01536: space quota exceeded for tablespace 错误的深入分析
- 由 ORA-01536: space quota exceeded for tablespace 引出的研究
- 由 ORA-01536: space quota exceeded for tablespace 引出的研究
- 由 ORA-01536: space quota exceeded for tablespace 引出的研究
- IT忍者神龟之 配额不足的解决方法ORA-01536: space quota exceeded for tablespace
- space quota exceeded for tablespace(表空间不足)
- ORA-01536: space quota exceed for tablespace "USERS"
- quota exceeded
- ORA-30041: Cannot grant quota on the tablespace
- ORA-12549: TNS:operating system resource quota exceeded.
- sample format
- Android 4学习(7):用户界面 - 基础
- Top 5 Questions about C/C++ Pointers 【转】
- HTML中<!DOCTYPE>标签的作用
- 数据流图的画法
- ORA-1536: space quota exceeded for tablespace "<name>"
- java 发邮件
- Android APK破解
- QT点滴记录,以便查阅
- 用来理解 Java 编程语言的 8 个图表
- DE4-530的OpenCL开发环境搭建
- InternalResourceViewResolver和UrlBasedViewResolver
- 2014百度校招笔试
- Android Cookbook