rowid方式在线重定义

1，建分区表
create table WEB_AD
(
  DATA_ID           INTEGER,
  USER_FLAG         VARCHAR2(100),
  AID               VARCHAR2(4000),
  URL               VARCHAR2(4000),
  REFERRER_URL      VARCHAR2(4000),
  IP_EX             VARCHAR2(4000),
  WEBSITE_ID        VARCHAR2(4000),
  NDS               VARCHAR2(1000),
  DESCRIPTION       VARCHAR2(4000),
  ACTION            INTEGER,
  ACTION_TIME       DATE,
  WINDOWS           VARCHAR2(512),
  SYS_DATE          DATE default sysdate,
  DATA_TYPE         INTEGER,
  USER_AGENT        VARCHAR2(512),
  SCREEN_RESOLUTION VARCHAR2(100),
  PID               VARCHAR2(200),
  SID               VARCHAR2(64),
  CID               VARCHAR2(200),
  RESERVE2          VARCHAR2(200),
  RESERVE3          VARCHAR2(200),
  RESERVE4          VARCHAR2(200),
  RESERVE5          VARCHAR2(200)
)
partition by range(sys_date) INTERVAL(NUMTODSINTERVAL(1,'DAY'))


(
partition p_2014_04_01 values less than (to_date('2014-04-01', 'yyyy-mm-dd'))
)


tablespace WEB_AD_TBS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 80K
    next 1M
    minextents 1
    maxextents unlimited

  );

2，判断
exec dbms_redefinition.can_redef_table(gather,'web_ad_data',DBMS_REDEFINITION.CONS_USE_rowid);


3,开始

exec dbms_redefinition.start_redef_table('gather,'web_ad_data', 'web_ad'，'DATA_ID DATA_ID，USER_FLAG USER_FLAG，AID AID，URL URL，REFERRER_URL REFERRER_URL，IP_EX IP_EX，WEBSITE_ID WEBSITE_ID，NDS NDS，DESCRIPTION DESCRIPTION，ACTION ACTION，ACTION_TIME ACTION_TIME，WINDOWS WINDOWS，SYS_DATE SYS_DATE，DATA_TYPE DATA_TYPE，USER_AGENT，USER_AGENT，SCREEN_RESOLUTION SCREEN_RESOLUTION，PID PID，SID SID，CID CID，RESERVE2 RESERVE2，RESERVE3 RESERVE3，RESERVE4 RESERVE4，RESERVE5 RESERVE5’,2）；

4,EXEC DBMS_REDEFINITION.FINISH_REDEF_TABLE(gather,'web_ad_data', 'web_ad'); 


5,select * from web_ad


6,drop table web_ad

7，rename