Exhibit:
View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables.
User A wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using
following insert command.
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
SELECT e.employee_id,
e.first_name ||’ ‘|| e.last_name,
e.salary,
d.department_name,
e.manager_id
FROM employees e,
departments d
where e.department_id = d.department_id;
While user A executes the command, it errors out, displaying the following error message:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
*
ERROR at line 1:
ORA-01653: unable to allocate extent table
A.EMP_DEP by 8 in tablespace USERS
What would have caused the error?
A.
The user A does not have space quota.
B.
RESOURCE role has not been granted to user A.
C.
User A does not have insert privilege on EMP_DEP table.
D.
The EMP_DEP table is residing on a temporary tablespace.
E.
The default tablespace of user A does not have enough free space.
F.
The tablespace where EMP_DEP table resides does not have enough free space.
Exhibit not showing
The ORA-01653 error is caused because you need to add space to a tablespace.
The Oracle docs note this on the ora-01653 error:
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.
unable to allocate table EMP_DEP