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.