Toad World® Forums

cluster partition


#1

CREATE CLUSTER c (x number) HASHKEYS 10 PARTITION BY RANGE (x) (PARTITION p1 VALUES LESS THAN (1));
If I describe “c”, it tells me : cluster does not exists
12.7.0.30 / oracle 12.1.0.2


#2

I have opened a service request by oracle because the cluster is in DBA_OBJECTS but not in DBA_CLUSTERS, I will update this thread with the bug, it is not related to Toad


#3

I don’t see any information about the partitions in the data dictionary either.


#4

yes, the partitions are listed in DBA_OBJECTS but not in DBA_CLU_PARTITIONS (the view does not even exist).

If you create table in the cluster, the partition of the clustered table (but not the partition definition of the cluster) are working.

Neither dbms_metadata nor datapump works properly with this object type


#5

Yeah I noticed that too about dbms_metadata. I didn’t look in dba_objects, but DBA_CLU_PARTITIONS (or DBA_TAB_PARTITIONS, if they are going to put there there) is really what Toad would need to create DDL. Also DBA_PART_TABLES or DBA_PART_CLUSTERS for default partition attributes. Really, I think we need separate views, because tables and clusters are in different namespaces (So, you could have both a table and cluster with the same name)


#6

support.oracle.com/…/BugDisplay Enhancement request filed