1Z0-043 · Question #118
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…
The correct answer is B. Coalesce the ORDERS_IND index. E. Rebuild the index online and move it to another tablespace. See the full explanation below for the reasoning.
Question
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)
Options
- ADrop and re-create the inbox.
- BCoalesce the ORDERS_IND index.
- CCoalesce the INDEXES tablespace.
- DDrop and re-create the ORDERS table.
- ERebuild the index online and move it to another tablespace.
How the community answered
(47 responses)- A9% (4)
- B70% (33)
- C17% (8)
- D4% (2)
Community Discussion
No community discussion yet for this question.