rowid方式在线重定义

来源：互联网发布：淘宝购物车登陆编辑：程序博客网时间：2024/04/30 11:47

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

0 0