[askdba] Table Partition issue

  • From: Abraham Kurian <kurian24@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 2 Dec 2004 15:12:49 +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 achive this by querying the data dictionary

Other related posts:

  • » [askdba] Table Partition issue