Re: INSERTING DATA IN ORACLE PARTITION TABLE

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

Then use a "where condition" with "CTAS"

so the method is the same as I sent you in my previous update

2016-10-03 10:06 GMT+03:00 Arsala [via Erman Arslan's Oracle Forum] <[hidden email]>:

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')));

---

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-tp1349p1352.html

To start a new topic under Erman Arslan's Oracle Forum, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--