1Z0-062 · Question #2
The hr user receiver, the following error while inserting data into the sales table: On investigation, you find that the users tablespace uses Automnrif Segment Space Management (ASSM). It is the…
The correct answer is A. Altering the data life associated with the USERS tablespace to ex automatically B. Adding a data life to the USERS tablespace. When a tablespace runs out of space, you resolve it by enabling autoextend on an existing datafile or by adding a new datafile to the tablespace.
Question
The hr user receiver, the following error while inserting data into the sales table:
On investigation, you find that the users tablespace uses Automnrif Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it. Which two methods would you use to resolve this error?
Options
- AAltering the data life associated with the USERS tablespace to ex automatically
- BAdding a data life to the USERS tablespace
- CChanging segment space management for the USERS tablespace to manual
- DCreating a new tablespace with autoextend enabled and changing the default tablespace of the
- EEnabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a
How the community answered
(22 responses)- A73% (16)
- C5% (1)
- D18% (4)
- E5% (1)
Why each option
When a tablespace runs out of space, you resolve it by enabling autoextend on an existing datafile or by adding a new datafile to the tablespace.
Altering the existing datafile to autoextend allows Oracle to automatically grow the file when space is exhausted, directly resolving an ORA-01653 or similar space error.
Adding a new datafile to the USERS tablespace immediately provides additional storage, so subsequent inserts can allocate the extents they need.
Changing segment space management from ASSM to manual affects how free space is tracked within segments, not the total amount of space available, so it does not fix a space exhaustion error.
Creating a new tablespace and changing the user's default tablespace is a valid long-term approach but requires migrating existing objects and is not a direct fix for the current error on the existing table.
Setting RESUMABLE_TIMEOUT suspends the failing statement temporarily to allow manual intervention rather than actually resolving the underlying space shortage.
Concept tested: Oracle tablespace space management and datafile configuration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-data-files-and-temp-files.html
Topics
Community Discussion
No community discussion yet for this question.