注册 登录
编程论坛 Oracle论坛

oracle 分区表各

huberyWei 发布于 2016-04-29 14:11, 5821 次点击
新建一个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的值?
   
0 回复
1