Database Administration (MOSC)

MOSC Banner

We are facing Huge size occupation by BLOB segment - Single segment Size 6TB

edited Mar 6, 2024 1:05PM in Database Administration (MOSC) 3 commentsAnswered

Hi

We are trying to archive some data from one table which is having BLOB column .

Its LOB segment size is 6TB.

We tried to export FY20 data from the table & deleted the same data from the table.Its around 430GB. Taken 5Hrs to export with parallelism 16 & deletion of same data taken 30Mins.

After deletion also space not released from the table , same before & after deletion of data from the table.

So trying to shrink table size using

ALTER TABLE prod_ifmis.Tablename MODIFY LOB(lob column) (SHRINK SPACE CASCADE);

But its running since 2 days .

Also one clarification , Is the space ( rows deleted from table space ) used by the table for the new insertions?

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