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!

SYS_IL

733008Sep 23 2010 — edited Sep 23 2010

Hi all,
i have a tablespace used for lob storage.
looking at objects i can see lob_subpartition and index_subpartition
I'd like to know the relation between a lob_subpartition and his own index_subpartition

using dba_lob_partitions i can see that SYS_LOB_SUBP4758 is related ti table EMP partition 2010 subpartition SEPTEMBER
SYS_LOB0000088437C00005$$:SYS_LOB_SUBP4758

but when i have
SYS_IL0000088437C00005$$:SYS_IL_SUBP4760

what view i can check to see which is the subpartition related?

Sorry for my english and thank you in advance :)

This post has been answered by rajeysh on Sep 23 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2010

Added on Sep 23 2010

#general-database-discussions

3 comments

2,448 views