[askdba] Re: Partition Tables

  • From: Abraham Kurian <kurian24@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 2 Dec 2004 15:35:32 +0530

whats this Values_less_than ?


On Thu, 2 Dec 2004 09:57:51 +0000, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote:
> 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: