Re: dba_tab_partitions

Why join them at all?

Just look at dba_segments and tab_tab_partitions for segment_type of "TABLE PARTITION" , joined between partition_name.

I'm not sure where dba_data_files comes in if you want the size of the partition segments.

On Fri, Jun 6, 2008 at 10:37 AM, Joe Smith <joe_dba_at_hotmail.com> wrote:

> What is the most efficient way to join dba_data_files and
> dba_tab_partitions to select num_rows and bytes to display both with a
> single query?
>
>
> thanks.
>
>
> ------------------------------
> Enjoy 5 GB of free, password-protected online storage. Get Windows Live
> SkyDrive.<http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008>
>

-- 
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
Last.fm: http://www.last.fm/user/piontekdd/

--
http://www.freelists.org/webpage/oracle-l