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.
The question is to insert data into scott.emp_dep table, but there is not enough space.
In this case increase the table space methods are:
1. add a data file.
2. increase the table space in which can resize the data file
3. the automatic extension table space
To change the size of a newly added datafile or tempfile in smallfile tablespaces, use the ALTER DATABASE … autoextend_clause (see database_file_clauses ).
For each datafile in the tablespace, this clause combines all contiguous free extents into larger contiguous extents. Use this clause to rename tablespace .
ORA-01653: unable to extend table string. string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.