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?
check PARTITIONED column in DBA_TABLES and DBA_INDEXES.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
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.
That was exactly what I needed.
Click Here to Expand Forum to Full Width