ORA-01536: 超出表空间 'USERS' 的空间限额

2015-02-02 18:04:40 · 作者: · 浏览: 9

SQL> conn hr/***
SQL> create table s_employee_test as select * from employees;


create table s_employee_test as select * from employees


ORA-01536: 超出表空间 'USERS' 的空间限额


解决:


sqlplus "sys/*** as sysdba"
SQL>? alter user hr quota unlimited on users;


用户已更改。


SQL> conn hr/***
SQL> create table s_employee_test as select * from employees;


Table created