Re: Database partitioning

Posted by ErmanArslansOracleBlog on Jun 07, 2022; 3:06pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-partitioning-tp10937p10939.html

CTAS or INSERT APPEND PARALLEL - based method may be more feasible..

Example For CTAS;

SQL>alter session enable parallel dml;
SQL> create table partbl (qty, name) partition by range (qty) (partition p1 values less than (501),partition p2 values less than (maxvalue))
  2  as select /*+PARALLEL*/ * from origtbl;


Example for INSERT :

SQL>alter session enable parallel dml;
SQL> insert /*+APPEND PARALLEL*/ into partbl (qty, name) select * from origtbl;