Link to home
Start Free TrialLog in
Avatar of luyan
luyan

asked on

Modify the partition

I created one table with a RANGE PARTITION.
CREATE TABLE SAMPLE_ORDERS
(ORDER_NUMBER NUMBER,
ORDER_DATE DATE,
SHIPPING_DATE DATE,
CUST_NUM NUMBER,
TOTAL_PRICE NUMBER,
TOTAL_TAX NUMBER,
TOTAL_SHIPPING NUMBER)
PARTITION BY RANGE(ORDER_DATE)
(
PARTITION SO99Q1 VALUES LESS THAN TO_DATE(01-APR-2005, DD-MON-YYYY),
PARTITION SO99Q2 VALUES LESS THAN TO_DATE(01-JUL-2005, DD-MON-YYYY),
PARTITION SO99Q3 VALUES LESS THAN TO_DATE(01-OCT-2005, DD-MON-YYYY),
PARTITION SO99Q4 VALUES LESS THAN TO_DATE(01-JAN-2006, DD-MON-YYYY),
PARTITION SO00Q1 VALUES LESS THAN TO_DATE(01-APR-2006, DD-MON-YYYY),
PARTITION SO00Q2 VALUES LESS THAN TO_DATE(01-JUL-2006, DD-MON-YYYY),
PARTITION SO00Q3 VALUES LESS THAN TO_DATE(01-OCT-2006, DD-MON-YYYY),
PARTITION SO00Q4 VALUES LESS THAN TO_DATE(01-JAN-2007, DD-MON-YYYY)
)
;

I want to modify the partition based on SHIPPING_DATE. Whats the steps for implement it?
Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of luyan
luyan

ASKER

Thanks for help!