TABLESPACE_NAME MAX_BLOCKS COUNT_BLOCKS SUM_FREE_BLOCKS PCT_FREE
-------------------- ---------- ------------ --------------- ----------
USERS 7480 1 7480 97.3958333SQL> create table test(group1 number,var number);create table test(group1 number,var number)ORA-01536: 超出表空间'USERS'的空间限量SQL>
USERS表空间空闲97.3958333%,系统却显示:ORA-01536: 超出表空间'USERS'的空间限量,各位这该如何理解及解决,谢谢..
-------------------- ---------- ------------ --------------- ----------
USERS 7480 1 7480 97.3958333SQL> create table test(group1 number,var number);create table test(group1 number,var number)ORA-01536: 超出表空间'USERS'的空间限量SQL>
USERS表空间空闲97.3958333%,系统却显示:ORA-01536: 超出表空间'USERS'的空间限量,各位这该如何理解及解决,谢谢..
或者该用户的默认表空间不是users表空间
试试 create table test(group1 number,var number) tablespace users;