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