Re: INSERTING DATA IN ORACLE PARTITION TABLE

Posted by Arsalan on Oct 03, 2016; 7:04am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/INSERTING-DATA-IN-ORACLE-PARTITION-TABLE-tp1349p1351.html

Thanks for quick reply.

Sir I want to insert data in partition table date wise not all  data
from source table just a few specific date of data.

CREATE TABLE sales_info
 (
 emp_id NUMBER NOT NULL,
 join_date DATE NOT NULL,
 email VARCHAR2(100)
 )
 PARTITION BY RANGE (join_date)
 (
 PARTITION emp_info_p0 VALUES LESS THAN (TO_DATE('01-JAN-2011', 'DD-MON-YYYY')),
PARTITION emp_info_p1 VALUES LESS THAN (TO_DATE('01-JAN-2012', 'DD-MON-YYYY')),
 PARTITION emp_info_p2 VALUES LESS THAN (TO_DATE('01-JAN-2013', 'DD-MON-YYYY')),
PARTITION emp_info_p3 VALUES LESS THAN (TO_DATE('01-JAN-2014', 'DD-MON-YYYY')) ,
 PARTITION emp_info_p4 VALUES LESS THAN (TO_DATE('01-JAN-2015',
'DD-MON-YYYY')));



On 10/3/16, ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum]
<[hidden email]> wrote:

>
>
> USE "CREATE TABLE AS SELECT" (CTAS)
>
> Example:
>
> CREATE TABLE SUN_PART_EMP
> PARTITION BY hash(deptno) PARTITIONS 2
> AS SELECT * FROM EMP;
>
>
>
> _______________________________________________
> If you reply to this email, your message will be added to the discussion
> below:
> http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/INSERTING-DATA-IN-ORACLE-PARTITION-TABLE-tp1349p1350.html
>
> To unsubscribe from INSERTING DATA IN ORACLE PARTITION TABLE, visit
>

Free forum by Nabble

Edit this page