The hr user receiver, the following error while inserting data into the sales table:
ERROR at line 1:
ORA-01653; unable to extend table HR.SALES by 128 in tablespace USERS
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?
A.
Altering the data life associated with the USERS tablespace to ex automatically
B.
Adding a data life to the USERS tablespace
C.
Changing segment space management for the USERS tablespace to manual
D.
Creating a new tablespace with autoextend enabled and changing the default tablespace of the
HR user to the new tablespace
E.
Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a
nonzero value
Explanation:
A, B
“Data life”, does it mean to “data file”?
A,B
D is nonsense
Hugo I think this is the perfect description. D is nonsense!
B will wrong if that tablespace is bigfile tablespace (maximum 1 data file)! Correct: A & D
A,B
i think A-B is correct
ORA-01653: unable to extend table string. string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Add a DATAFILE
Resize DATAFILE
Enable AUTOEXTEND
AB
AB
I believe AD is correct since this table space could be a bigfile tablespace, and you have more than one data file in a bigfile tablespace.
This is not sense, a bigfile tablespace only have a datafile.
A and B
A B
AD
not D.
Even if you change the default tablespace for HR, the SALES table will stay on the USERS tablespace.
And you still won’t be able to insert into SALES.
so AB