Oracle大将军

<br />alter table tbparttest split partition POTHERS　at (TO_DATE(' 2011-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))<br />into (partition p201111, partition pothers);

How To Partition Existing Table Using DBMS_Redefinition [ID 472449.1] --------------------------------------------------------------------------------  修改时间 28-SEP-2010     类型 HOWTO     状态 MODERATED   In this Document  Goal  Solution-----------------------

<br />Goal<br />You have a range partitioned table with local indexes on it. As a part of policy or to save disk space being used by the tables, you would like to archive the data so that if needed you can restore the data back.<br /><br />Note: - This doc

<br /> <br />How To Move Or Rebuild A Lob Partition [ID 761388.1]    <br />     <br />  修改时间 29-JUN-2010     类型 HOWTO     状态 MODERATED    <br />In this Document<br />  Goal<br />  Solution<br />  References<br /> <br />Platforms: 1-914CU; <br /> <br />This

PURPOSE  This document details methods of splitting a large table partition that  will minimize downtime.SCOPE & APPLICATION  InstructionalRELATED DOCUMENTS  Oracle8 Server Administrator's Guide, Chapter 11.How to Split Partition of Heavily Used Table:====

How to move or transport table partition using Transportable Table Space (TTS)? [ID 731559.1] -------------------------------------------------------------------------------- 修改时间 03-AUG-2009 类型 HOWTO 状态 MODERATED In this Document