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?
Exhibit:
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.
Answer: F
ORA-01653: unable to extend table string.string by string in tablespace string