Pages

Saturday, 30 November 2013

How do I know if an object is partitioned or not?



A simple query against the data dictionary will show if a given table or indexe is partitioned or not:
Code:
SELECT * FROM dba_part_tables;
SELECT * FROM dba_part_indexes;

No comments:

Post a Comment

Enter Your Question

Total Pageviews

Blog