Re: INSERTING DATA IN ORACLE PARTITION TABLE

Posted by ErmanArslansOracleBlog on Oct 03, 2016; 6:43am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/INSERTING-DATA-IN-ORACLE-PARTITION-TABLE-tp1349p1350.html

USE "CREATE TABLE AS SELECT" (CTAS)

Example:

CREATE TABLE SUN_PART_EMP
PARTITION BY hash(deptno) PARTITIONS 2
AS SELECT * FROM EMP;