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

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -