Database DataWarehousing (MOSC)

MOSC Banner

alter query to partition a non-partitioned table in oracle 9i

edited Sep 12, 2011 7:24PM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓
could anybody give a example to alter a non-partitioned table for adding partition. example: i have created a table with struture :

CREATE TABLE SALES_RANGE_NEW (salesman_id NUMBER(5), salesman_name VARCHAR2(30), sales_amount NUMBER(10), sales_date DATE);

now i want to add range partition in it on column sales_date as:

PARTITION sales_jan2000 VALUES LESS THAN(TO_DATE('02/01/2011','DD/MM/YYYY')),

PARTITION sales_feb2000 VALUES LESS THAN(TO_DATE('03/01/2011','DD/MM/YYYY')),

PARTITION sales_mar2000 VALUES LESS THAN(TO_DATE('04/01/2011','DD/MM/YYYY')),

PARTITION sales_apr2000 VALUES LESS THAN(TO_DATE('05/01/2011','DD/MM/YYYY'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center