Identify two actions either of which will help you resolve this problem…

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.)

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.



Leave a Reply 1

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


Julio

Julio

Hi! Quick question that’s totally off topic. Do you know how to make your
site mobile friendly? My website looks weird when viewing from my iphone
4. I’m trying to find a theme or plugin that might be
able to fix this issue. If you have any suggestions, please share.
Thank you!
bayern munchen norge