Oracle Database Discussions

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!

Match log segment with table partition

himmyMar 16 2015 — edited Mar 19 2015

Hello Dba's

In one of our 10.2.0.4 database we have a range based monthly partitioned table and it has a column type lob in it.

Now i have to find the corresponding lob segment of the partitions of the table. what data dictionary tables can help me achieve it.

This is mainly for space management as we have to drop partitions older than 2 months and release space.

Please help me

Thanks

Himanshu

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2015

Added on Mar 16 2015

#general-database-discussions

3 comments

1,042 views