Database Tuning (MOSC)

MOSC Banner

Nullable CLOB and reclaim space

Oracle database 11.2.0.3 Enterprise Edition RAC on AIX

I have a huge table (30 TB) that contains CLOB. Here are contained data since ten year ago or maybe more.

Now we can clean some data making NULL all the CLOB neither the last year.

So at the end we'll have a "small" table with a lot of empty CLOB.

The question is: if we partition the table for "year", during the partitioning the table is reorganized so we can reclaim space ?

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