dba_tab_partitions

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Fri, 6 Jun 2008 10:37:30 -0500
Message-ID: <BLU108-W3432E441BFC25867E4EE1097B70@phx.gbl>

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. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008

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

Received on Fri Jun 06 2008 - 10:37:30 CDT