Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to drop LOB columns ?

AJay BMar 31 2015 — edited Mar 31 2015

I am trying to drop a lob column from a table using "ALTER TABLE tab2 DROP COLUMN col1;", But I still see the segments still occupied and the LOB storage haven't been released. How to release it ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2015
Added on Mar 31 2015
1 comment
1,164 views