finding information on IOT overflow segments
I'm trying to get information on some partitioned IOT tables. Specifically, how the overflow segments were set up.
I'm looking at user_indexes.include_column, but it is zero for all my IOTs. Does that mean there are no overflow segments? I see some in the schema but don't know how to match each overflow segment up to its parent partition.
I suppose I could extract the DDL and look at the INCLUDING or PCTTHRESHOLD clauses; but there must be some way to see this in the data dictionary.
I just don't know how to interpret the 0 in include_column!
I'm looking at user_indexes.include_column, but it is zero for all my IOTs. Does that mean there are no overflow segments? I see some in the schema but don't know how to match each overflow segment up to its parent partition.
I suppose I could extract the DDL and look at the INCLUDING or PCTTHRESHOLD clauses; but there must be some way to see this in the data dictionary.
I just don't know how to interpret the 0 in include_column!
0