Database Administration (MOSC)

MOSC Banner

Reclaim CLOB space from a table.

edited Jun 26, 2017 5:00AM in Database Administration (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center