check partition maxvalue is reached
Hello
We are using 11.2.0.4 on AIX and we have many tables partitioned using range - Now I want to get list of tables which have rows on the maxvalue partition or on the partition which is one level less than maxvalue . Example
PARTITION p0 VALUES LESS THAN (6),
PARTITION p1 VALUES LESS THAN (11),
PARTITION p2 VALUES LESS THAN (16),
PARTITION p3 VALUES LESS THAN MAXVALUE
Now if partitions p2 and p3 have any rows in them I want to list the table names. Please let me how to find out these tables using SQL query