Subpartitioning

[Peer Jones]

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

[SANJAY_G]

check PARTITIONED column in DBA_TABLES and DBA_INDEXES.

[slimdave]

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.

[Peer Jones]

Thanks, Guys,
That was exactly what I needed.
Bye
Peer