TECHNOLOGY: Inside OCP
READ more Inside OCP
ORA-10635: Invalid segment or tablespace type
What could be the reason for the error?
A. The SALES_TBS tablespace is read/write and not read-only.
B. The SALES_TBS tablespace is online and not offline.
C. The segment-space management for the SALES_TBS tablespace is manual and not automatic.
D. The SALES_TBS tablespace is not autoextensible to an unlimited size.
The correct answer is C.
Shrink operations can be performed only on segments in tablespaces that use automatic segment-space management. You need not make a tablespace read-only, offline, or autoextensible before shrinking any of the segments in that tablespace.
This column has discussed topics associated with upgrading from an Oracle9i DBA Certified Professional credential to an Oracle 10g DBA Certified Professional credential. Automatic Shared Memory Management significantly simplifies Oracle database administration and helps make more-effective use of available memory. Online segment shrink can improve the performance of full table scans and index access. Also, by shrinking sparsely populated segments, online segment shrink can enhance the efficiency of space utilization inside your database.