INSERTING DATA IN ORACLE PARTITION TABLE

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


how to insert data from source table to partition table in oracle 11g.  ???????????


SQL> desc sales
 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------------
 PROD_ID                                   NOT NULL NUMBER
 CUST_ID                                   NOT NULL NUMBER
 TIME_ID                                   NOT NULL DATE
 CHANNEL_ID                                NOT NULL NUMBER
 PROMO_ID                                  NOT NULL NUMBER
 QUANTITY_SOLD                             NOT NULL NUMBER(10,2)
 AMOUNT_SOLD                               NOT NULL NUMBER(10,2)
--------------------

create table sales_part
( prod_id number(23),
cust_id number(23),
time_id date,
channel_id number(23),
promo_id number(23),
quatity_sold number(23),
amount_sold number(23)
)
partition by range (time_id)
(
PARTITION emp_info_p0 VALUES LESS THAN (TO_DATE('01-JAN-1998', 'DD-MON-YYYY')),
PARTITION emp_info_p1 VALUES LESS THAN (TO_DATE('01-FEB-1998', 'DD-MON-YYYY')),
 PARTITION emp_info_p2 VALUES LESS THAN (TO_DATE('01-MAR-1998', 'DD-MON-YYYY')),
PARTITION emp_info_p3 VALUES LESS THAN (TO_DATE('01-APR-1998', 'DD-MON-YYYY')),
 PARTITION emp_info_p4 VALUES LESS THAN (TO_DATE('01-MAY-1998', 'DD-MON-YYYY')));