Reclaim CLOB space from a table.
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc error_journal_msg_in_error
Name Null? Type
----------------------------------------- -------- ----------------------------
ERROR_JOURNAL_SID NOT NUL NUMBER(19)
SERVICES_MESSAGE_XML CLOB
I have this table with a CLOB that I want to delete records from. I want to reclaim the space afterwards. All I have to do is run the following command?
sql>ALTER TABLE ERROR_JOURNAL_MSG_IN_ERROR MODIFY LOB (SERVICES_MESSAGE_XML) (SHRINK SPACE);
It is that simple?
thanks.