Re: INSERTING DATA IN ORACLE PARTITION TABLE

Posted by Arsalan on Oct 03, 2016; 7:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/INSERTING-DATA-IN-ORACLE-PARTITION-TABLE-tp1349p1352.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')));