oracle index中的TABLESPACE名字怎么批量更新
CREATE UNIQUE INDEX DSZFOA.BASICDATA_ID_KEY ON DSZFOA.TBL_COMN_BASICDATA
(BDATA_ID)
LOGGING
TABLESPACE DSOA
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 192K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOPARALLEL;
大家看,我的表名是DSZFOA,但是TABLESPACE DSOA,所有的索引都是这样,我想批量修改,修改后需要rebulid吗?