SQL Language (MOSC)

MOSC Banner

check partition maxvalue is reached

edited Apr 10, 2015 10:02AM in SQL Language (MOSC) 1 commentAnswered

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



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center