-
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.
Sanjay G.
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.
-
Thanks, Guys,
That was exactly what I needed.
Bye
Peer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|