The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace.
Which three action would allow the user to insert data? (Choose three.)
A.
Add a data file to the SMD tablespace.
B.
Add a data file to the temporary tablespace associated with the user HR.
C.
Resize the data file associated with the SMD tablespace to make it larger.
D.
Alter the data file associated with the SMD tablespace to grow automatically.
E.
Change the segment space management for the SMD tablespace to automatic.
Explanation:
The Oracle docs note this on the ora-01653 error:
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.
Oracle MOSC Documents offer great resources on resolving ORA-01653, namely the nature of
the problem as it relates to space availability:
————This error does not necessarily indicate whether or not you have enough space in the tablespace,
it merely indicates that Oracle could not find a large enough area of free contiguous space inwhich to fit the next extent.
Diagnostic Steps:
—————–1. In order to see the free space available for a particular tablespace, you must use the view
DBA_FREE_SPACE. Within this view, each record represents one fragment of space. How the
view DBA_FREE_SPACE can be used to determine the space available in the database is
described in Note 121259.1 Using DBA_FREE_SPACE
Furthermore, MOSC offers these choices in resolving ORA-01653 (as quoted below):
Manually COALESCE Adjacent Free Extents
Add a DATAFILE
Resize DATAFILE
Enable AUTOEXTEND
Defragment tablespace
View temporary segments for space