Users in your production database complain that they are getting the following error message
while trying to insert rows into the ORDERS table:
ERROR at line 1:
ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES
While investigating, you find that the INDEXES tablespace has run out of space and there is no
more free space on the disk where the data files are available.
Which two actions could you perform to overcome this error without affecting the queries that are
currently being executed? (Choose two)
A.
Drop and re-create the inbox.
B.
Coalesce the ORDERS_IND index.
C.
Coalesce the INDEXEStablespace.
D.
Drop and re-create the ORDERS table.
E.
Rebuild the index online and move it to anothertablespace.