oracle11g - Change partition interval column in Oracle -
we have 1 table range interval partition defined on 1 of column. change partition column other column same table. can that? able in sql developer--> edit table --> partitions need script , not through ui.
below example:
create table partition_test ( prod_id number not null, url varchar2(100 byte), date_sk number ) partition range (prod_id) interval(100) (partition part_min values less (20051001));
now change column prod_id date_sk. can me pl/sql script same.
Comments
Post a Comment