What would have caused the error?

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?

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 tablespace where EMP_DEP table resides does not have enough free space.

B.
The user A does not have space quota.

C.
RESOURCE role has not been granted to user A.

D.
User A does not have insert privilege on EMP_DEP table.

E.
The EMP_DEP table is residing on a temporary tablespace.

F.
The default tablespace of user A does not have enough free space.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *