[askdba] Re: Partition Tables

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 2 Dec 2004 10:47:29 +0000

Sorry Mate .. The Woes of using a Tool to Query on ... 

Anyways U dont have any direct way to do that .. Create another table
that has a Clob Datatype and select from that ...

Sorry once again .... 
:)


On Thu, 2 Dec 2004 15:35:32 +0530, Abraham Kurian <kurian24@xxxxxxxxx> wrote:
> 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: