Re: Partition Information

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Sat, 09 Feb 2002 06:08:11 GMT
Message-ID: <f1398.102$823.83053742@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 - 00:08:11 CST