新建一个oracle分区表如下
-- Create table
create table customer
(
id VARCHAR2(32) not null,
customer_name VARCHAR2(255) not null,
customer_gender VARCHAR2(32) not null,
customer_phone VARCHAR2(150) not null,
customer_period CHAR(6) not null
) partition by list(customer_period) (
partition current_partition values('201101'),
partition list_partition values('201102')
);
插入以下数据
INSERT INTO MMS_TARGET_CUSTOMER (ID, CUSTOMER_NAME, CUSTOMER_GENDER, CUSTOMER_PHONE, CUSTOMER_PERIOD) VALUES
('abc42f8164c243c885a8adfzz4zr8', '张三', '男', '12345678900', '201101');
此时我想将该数据迁移到list_partition 分区中,然后插入一条customer_period为'201201' 的数据到current_partition 中。
请问Oracle数据库是否支持此功能,能否修改values的值?