Oracle Partitioning Basics/title> <link href="Templates/og.css" rel="stylesheet" type="text/css">  <meta name="description" content="Your online resource for Oracle 10g, Oracle DBA, Business Intelligence and Oracle Database information."> <meta name="keywords" content="oracle 10g, business intelligence, oracle dba, oracle database, oracle discoverer, plsql programming, oracle plsql"> <meta name="author" content="OracleGiants.com"> <meta name="generator" content="Dreamweaver"> <meta name="revisit-after" content="3 days"> <meta http-equiv="title" content="Oracle 10g | Business Intelligence | Oracle DBA | Oracle Database"> <meta name="copyright" content="2006"> <meta name="distribution" content="Global"> <meta name="rating" content="General"> <META NAME="ROBOTS" CONTENT="INDEX, NOFOLLOW"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css">  </style>  </head> <body bgcolor="#FFFFFF" text="#000000" link="#003399" vlink="#6699FF" alink="#003399"> <div align="center"> <tr> <tr> <td> <table width="750" border="0" cellspacing="0" cellpadding="0" background="/images/og_logo.jpg" height="137"> <tr> <td width="154" valign="middle"> <table width="154" border="0" cellspacing="0" cellpadding="0"> <tr> <td valign="middle"> </td> </tr> <tr> <td valign="middle"> </td> </tr> <tr> <td valign="middle"> </td> </tr> </table> </td> <td valign="bottom" width="596"> <table border="0" cellspacing="0" cellpadding="0" height="52"> <tr valign="middle"> <td height="52" colspan="2"> </td> </tr> <tr> <td width="434"> <font color="#003399" size="4" face="Verdana, Arial, Helvetica, sans-serif">Welcome to <a href="http://www.oraclegiants.com">OracleGiants.com</a>!</font> </td> <td width="162"> <h1><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b><a href="http://www.oraclegiants.com">Oracle 10g DBA</a> & Business Intelligence Resources.</b></font></h1> </td> </tr> </table> </td> </tr> </table> <table width="750" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="3" align="right"><img src="/images/vline.gif" width="750" height="3"> </tr> <tr> <td width="5%" align="right"><font size="-1"></font></td> <td align="left"><script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></td> <td width="5%"><font size="-1"></font></td> </tr> <tr> <td colspan="3" height="10px" align="right"><img src="/images/vline.gif" width="750" height="3"></td> </tr> </table> <table valign="top" width="750" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="top"> </td> <td rowspan="7" width="1%"><img src="/images/vline.gif" width="3" height=100%></td> <td width="68%" rowspan="7" valign="top"> <font face="Verdana, Arial, Helvetica, sans-serif"><font size="2"><strong>Oracle Partitioning Basics</strong> <p> <strong>Partitioning</strong> is most helpful when the table contains many rows. Additionally it can be immensely beneficial if queries accessing <strong>partitioned tables</strong> perform full-table scans. In these cases some indexes can be removed from tables there by improving INSERT and UPDATE operations. <p> Using the following SQL to display partitioned tables within your environment <span class="sourcecode"><br>select owner || '.' || table_name, PARTITIONING_TYPE from dba_part_tables ORDER BY table_name; </span></font></font> <p><script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></p> </td> </tr> <tr> <tr> <td align="center" valign="top" width="31%"><p> </p> <p><font face="Verdana, Arial, Helvetica, sans-serif">Use <a rel="follow" href="http://www.xattr.com/product.html">Xattr CloudFiler™</a> to dedup, encrypt and move your RMAN backups to the cloud.</font></p> <p><font face="Verdana, Arial, Helvetica, sans-serif"><a href="http://www.xattr.com/product.html"><img src="http://xattr.com/images/xattr_72.gif" alt=""></a></font></p></td> </tr> <td width="31%" align="center" valign="top"> <p align="left"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><b>Recent Posts</b></font> </p> <div align="left"> <ul> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/_TRACE_FILES_PUBLIC Oracle Database.html">_TRACE_FILES_PUBLIC</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/db file sequential read.html">db file sequential read</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/_kks_use_mutex_pin.html">_kks_use_mutex_pin</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Basics of PGA_AGGREGATE_TARGET.html">Basics of PGA_AGGREGATE_TARGET</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Slow Access on Oracle Tablespaces.htm">Slow Access on Oracle Tablespaces</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle High Cluster Wait events.htm">High Cluster Wait events</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle Pin objects in Shared Pool.htm">Pin Objects in Shared Pool</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/db_keep_cache_size.htm">db_keep_cache_size</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/db_cache_size.html">db_cache_size</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/FilesystemIO_options oracle database.htm">FilesystemIO_options Initialization Parameter</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle Desupport for 10g AS 9.0.4.htm">Oracle Desupport for 10g AS (9.0.4)</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Insufficient Swap Space is configured on Oracle Application Server.htm">Insufficient Swap Space is configured on Oracle Application Server</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle Forms Services Web Runtime Pooling.html">Oracle Forms Services Web Runtime Pooling</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/64-bit Oracle Database.htm">64-bit Oracle Database</a></font><br> </li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle Application Server Backup and Recovery Tool.html">Oracle Application Server Backup and Recovery Tool</a></font> </li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle FRM-93000 error.htm">FRM-93000 Error</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Transparent Application Failover.htm">Transparent Application Failover</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle Services and Resource Manager Plans.htm">Oracle Services & Resource Manager Plans</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/db file parallel write.htm">db file parallel write</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/High Av Rd ms.htm">High Av Rd(ms)</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle OPTIMIZER_MODE OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING.htm">OPTIMIZER_MODE OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle partition table basics.html">Oracle partition table basics</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/latch free.html">latch free</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/latch cache buffers chains.html">latch cache buffers chains</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Log file switch checkpoint incomplete.html">Log file switch (checkpoint incomplete)</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/How to enable SQLNET ORA tracing.htm">How to enable SQLNET.ORA tracing</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/ORA-00060 deadlock detected while waiting for resource.htm">ORA-00060: deadlock detected while waiting for resource</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="Global Temporary Tables Tip.htm">Global Temporary Tables Tip</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="oracle traceability.htm">Oracle Traceability</a></font></li> <li><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><a href="optimizer_mode.htm">optimizer_mode</a></font></li> <li><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><a href="read by other session.htm">read by other session</a></font></li> <li><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><a href="log file parallel write.htm">log file parallel write </a></font></li> <li><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><a href="Oracle Forms and Reports Roadmap.htm">Oracle's Forms and Reports Roadmap</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="Excessive hard parsing.htm">Excessive hard parsing</a></font></li> <li><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><a href="Favor Indexes over Full Table Scans.htm">Favor Indexes over Full Table Scans</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="SQL Net message from client.htm">SQL*Net message from client</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="table fetch continued row.htm">table fetch continued row</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="table fetch continued row II.htm">table fetch continued row (Part 2)</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="enq TX - row lock contention.htm">enq: TX - row lock contention</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle-Portal-Weather-Portlet.htm">Weather Portlet for Oracle Portal</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Active-Directory-OID-Integration.htm">AD to OID Integration</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-case-insensitive-sorts.htm">Case Insensitive Sorts</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-recycle-bin-10g.htm">10g Recycle Bin Issue</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-10g-portal.htm">Oracle 10g Portal</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/business-intelligence-strategy.htm">Business Intelligence: Develop a strategy first<br> </a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-dba-becoming-one.htm">Oracle 10g DBA: How I became an Oracle 10g DBA</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-dba-normal-day.htm">Oracle 10g DBA: Day in the life of</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-application-server-install.htm">Oracle 10g Application Server: High Level Overview of Install</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/application-server-startup-script.htm">Oracle 10g Application Server: Multiple Home Installation on SLES Linux</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle-DBA-Itanium0.htm">Oracle 10g DBA: Oracle 10g & Itanium</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/business-intelligence-1.htm">Business Intelligence </a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"> <a href="/database-importance-design.htm">Understanding the Power that Comes From Your Database</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/database-data-visualization.htm">Mapping Software Improves Data Visualization</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/Oracle-Network-Monitor.htm">Oracle Network Monitor</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/SearchEngine_SourceCode.htm">An Open Source Search Engine</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/TNS-12564-TNS-connection-refused.htm">TNS-12564</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/ORA-31696-Data-Pump.htm">ORA-31696</a></font></li> <li><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/DBA_Code_Of_Ethics.htm">Database Administrator (DBA) Code of Ethics</a><br> </font></li> </ul> </div> </td> </tr> <tr> <td width="31%" align="center" valign="top"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><img src="/images/vline.gif" width="100%" height="3"></font></td> </tr> <tr> <td align="center" valign="top" width="31%"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"> <font size="-1" face="Verdana, Arial, Helvetica, sans-serif">OptionalRegion1</font></font></td> </tr> <tr> <td align="center" valign="top" width="31%"><font face="Verdana, Arial, Helvetica, sans-serif">This site recommends Burleson Consulting for <a rel="nofollow" href="http://www.remote-dba.net/">DBA Support & Consulting</a>.</font></td> </tr> <tr> <td align="center" valign="top" width="31%"> <div align="left"> <p><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><img src="/images/vline.gif" width="100%" height="3"></font></p> <p align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">We are currently paying for accepted <i><b>Oracle 10g DBA & Business Intelligence</b></i> articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.</font></p> <p align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><a href="/oracle-dba-write-articles.htm">Learn more</a></font></p> <p align="center"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><strong> Editorial submissions & questions: <a href="mailto:editor@oraclegiants.com">editor@oraclegiants.com</a></strong></font></p> <p> </p> </div> </td> </tr> <tr> <td align="center" valign="top" width="31%"> <p><img src="/images/vline.gif" width="100%" height="3"></p> <p> </p> <p><font face="Verdana, Arial, Helvetica, sans-serif" size="1">This site is moderated by an:<br> </font><img src="/images/oracle_logo1.gif" width="225" height="37" border="0" alt="Oracle Certified Professional"><br> <img src="/images/oracle_logo2.gif" width="144" height="22" border="0" alt="Oracle ACE"></p> <p> </p> </table> <table width="750" border="0" cellspacing="0" cellpadding="0"> <tr> <td align=left><img src="/images/vline.gif" width="750" height="3"></td> </tr> <tr> <td align=center> <div align="center"> <script type="text/javascript"></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td> </tr> <tr> <td align=center> <font face="Verdana, Arial, Helvetica, sans-serif" size="-2"> <a href="http://www.classic-caronline.com/">Classic Car Online - The #1 spot for classic and muscle car enthusiats</a></font></td> </tr> <tr> <td align=center> <font face="Verdana, Arial, Helvetica, sans-serif" size="-2">2010 OracleGiants.com </font> </td> </tr> </table> </div> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-860610-5"); pageTracker._trackPageview(); } catch(err) {}</script> </body> </html>