[askdba] Re: Partition Tables
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Thu, 2 Dec 2004 09:57:51 +0000
Select * from Dba_Tab_Partitions where Values_less_than = '01-DEC-2004'
HTH
Cheers
Ganesh
On Thu, 2 Dec 2004 14:54:30 +0530, Abraham Kurian <kurian24@xxxxxxxxx> wrote:
> 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:
