[askdba] Partition Tables

  • From: Abraham Kurian <kurian24@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 2 Dec 2004 14:54:30 +0530

Hi ,

            I have lots of partitioned tables in my schema , the
requirement is to identify the current partition of the table.

Let me explain this with an eg.

Lets say I have a table T , with 24 partitions .. starting for Jan -04
to Dec-05. Now , my current partition is Dec-04.

How can I achieve this by querying the data dictionary ?



Regards
Kurian

Other related posts: