052-180

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the
following error after the INSERT statement is issued and few rows are inserted:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
*
ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS
Identify two actions either of which will help you resolve this problem. (Choose two.)
A.Grant the RESOURCE role to SCOTT.
B.Add data files to the USERS tablespace.
C.Grant the CREATE ANY TABLE privilege to SCOTT.
D.Increase the space for SCOTT on the USERS tablespace.
E.Increase the size of the data file associated with the USERS tablespace.

ORA-01653 https://www.cnblogs.com/WAbby/p/6857531.html
报错是因为没有足够的空间。
增大表空间有三种方法:
1、增加一个文件:ALTER TABLESPACE users ADD DATAFILE '/u02/Oracle/data/users02.dbf' SIZE 1M;
2、改变原来数据文件的大小:ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users01.dbf' RESIZE 300M;
3、设置自动增长:ALTER TABLESPACE users ADD DATAFILE '/u02/oracle/rbdb1/users01.dbf' SIZE 10M AUTOEXTEND ON NEXT 512K MAXSIZE 250M;
故答案选 BE

posted @ 2017-12-15 13:46  巴啦啦大魔王  阅读(155)  评论(0编辑  收藏  举报