Re: Partition Information

From: Mukesh Singh <mksingh72_at_yahoo.com>
Date: 9 Feb 2002 13:53:55 -0800
Message-ID: <5d671409.0202091353.6ff5ae7a@posting.google.com>

Sure it helped.

Thanks,
Mukesh.

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:<f1398.102$823.83053742_at_newssvr13.news.prodigy.com>...
> Mukesh,
>
> Check those views:
>
> DBA_SEGMENTS
> DBA_PART_TABLES
> DBA_TAB_PARTITIONS
> DBA_TAB_SUBPARTITIONS
>
> for partition information.
>
> Hope that helps.
>
> Trifon Anguelov
> Senior Oracle DBA
>
> --------------------------------------
> Join the new Oracle DBA forums at:
> http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
>
>
>
>
>
> "Mukesh Singh" <mksingh72_at_yahoo.com> wrote in message
> news:5d671409.0202081404.488163da_at_posting.google.com...
> > Hi,
> >
> > How to get the information about the range partition on a table so
> > that another table can be created with having same range partitions
> > and same values ?
> >
> > How to find a record will go into which partition ?
> >
> > Thanks,
Received on Sat Feb 09 2002 - 15:53:55 CST