Toad World® Forums

Partition name greyed out

I have a table that has interval partition and sub partition by list.
On the partitioning tab it lists all the partition names and sub partitions are listed under the partition.

However one of the partition name is greyed out. Has someone noticed this and what would cause one partition to show up as greyed out whereas all other partitions show up as ok.

Please include a screen shot.


Please see attached

I think that's a bug. SYS_SUBP20652 should be grouped under a partition. I think that has something to do with it.

Can you send me the script to create the table, along with partitions and subpartitions?
I don't need table data, indexes, triggers, or storage options. Please send it to john.dorlon@quest.com.

Thanks

If I recreate the table in another schema by taking the script from Toad it shows up correctly

Ok, Please run each of these queries (you'll need to substitute your schema and table name).
Export the result into separate tabs of an excel spreadsheet and send to my email address above.

select partitioning_type, subpartitioning_type
, interval
, interval_subpartition, autolist, autolist_subpartition
, ref_ptn_constraint_name
from sys.DBA_PART_TABLES
where owner = :own
and table_name = :TableName;

select column_name
from sys.DBA_PART_KEY_COLUMNS
where owner = :own
and name = :objname
and object_type = :objtype
order by column_position;

select column_name
from sys.DBA_SUBPART_KEY_COLUMNS
where owner = :own
and name = :objname
and object_type = 'TABLE'
order by column_position;

Select PARTITION_POSITION, PARTITION_NAME,
HIGH_VALUE, HIGH_VALUE_LENGTH, TABLESPACE_NAME, NUM_ROWS, LAST_ANALYZED
,SUBPARTITION_COUNT
,COMPRESSION
,AVG_SPACE, BLOCKS, EMPTY_BLOCKS
FROM sys.DBA_TAB_PARTITIONS
WHERE TABLE_NAME = :obj
AND TABLE_OWNER = :own
ORDER BY PARTITION_POSITION;

Select SUBPARTITION_POSITION, SUBPARTITION_NAME, PARTITION_NAME, LAST_ANALYZED,
TABLESPACE_NAME, NUM_ROWS, HIGH_VALUE, COMPRESSION
, AVG_SPACE, EMPTY_BLOCKS, BLOCKS
FROM sys.DBA_TAB_SUBPARTITIONS
WHERE table_name= :obj
AND TABLE_OWNER = :own
ORDER BY PARTITION_NAME, SUBPARTITION_POSITION;