以下是oracle的错误解决方案。查看提示信息中所指定的表空间的容量。查看一下你所在的用户的默认表空间。 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.
把表空间增大 有两种方法可以完成 1、采用resize alter database datafile 'file_name' resize 200m; --file_name对应于表空间的数据文件 2、增加文件 alter tablespace tablespace_name add datafile 'new_file' size 100m;
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.
有两种方法可以完成
1、采用resize
alter database datafile 'file_name' resize 200m; --file_name对应于表空间的数据文件
2、增加文件
alter tablespace tablespace_name
add datafile 'new_file' size 100m;