-
Subpartitioning
Hi Everyone,
I've created some tables and indexes and partitioned and subpartitioned them.
The Enterprise Manager doesn't show me whether this was successfull or not.
Does anyone have a script querying the database, showing if the partitioned tables and indexes are actually in the assigned tablespaces?
Thanks
Peer
-
check PARTITIONED column in DBA_TABLES and DBA_INDEXES.
-
select partition_name,tablespace_name from dba_tab_partitions
where table_name = 'MY_TABLE';
Construct similar queries for dba_tab_subpartitions, dba_ind_partitions, dba_ind_subpartitions.
-
Thanks, Guys,
That was exactly what I needed.
Bye
Peer