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"
Forum Rules
Reply With Quote