Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Where are the partition ranges of a table stored?

Re: Q: Where are the partition ranges of a table stored?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Fri, 11 Dec 98 09:24:37 +0200
Message-ID: <ADrYCSsK42@protasov.kiev.ua>

Hi,

Try this:

select table_name,partition_name,high_value from user_tab_partitions order by 1,2;

Andrew Protasov

> I forgot what I initially set up my ranges on the partititons of my tables.
>
> What table can I use to look at these values?
>
> --
> ------------------------------------
> If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
> http://www.panix.com/~gsa/index.html
>
>
Received on Fri Dec 11 1998 - 01:24:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US