日本免费全黄少妇一区二区三区-高清无码一区二区三区四区-欧美中文字幕日韩在线观看-国产福利诱惑在线网站-国产中文字幕一区在线-亚洲欧美精品日韩一区-久久国产精品国产精品国产-国产精久久久久久一区二区三区-欧美亚洲国产精品久久久久

  1. 首頁 > 云知道 > >

oracle數(shù)據(jù)庫重啟命令 卸載oracle客戶端步驟( 二 )

云知道


-- Add comments to the table comment on table BN_SEQUENCE is 'This table stores the current sequence value of the business number.';-- Add comments to the columns comment on column BN_SEQUENCE.BN_RULE_GID is 'BN_RULE_GID contains the unique identifier for the Business Number (BN) rule.';-- Create/Recreate primary, unique and foreign key constraints alter table BN_SEQUENCE add constraint PK_BN_SEQUENCE primary key (BN_RULE_GID, BN_CONTEXT, BN_SEQUENCE_ID) using indextablespace INDX pctfree 10 initrans 2 maxtrans 255 storage ( initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0 );alter table BN_SEQUENCE add constraint FK_BN_SEQRULE_GID foreign key (BN_RULE_GID) references BN_RULE (BN_RULE_GID);-- Grant/Revoke object privileges grant select, insert, update, delete on BN_SEQUENCE to APP_USER;grant select on BN_SEQUENCE to APP_USER_SELECT;grant select, insert, update, delete on BN_SEQUENCE to EXT_USER;....7、校驗(yàn)數(shù)據(jù)

oracle數(shù)據(jù)庫重啟命令 卸載oracle客戶端步驟


結(jié)果：數(shù)據(jù)全部遷移了，保留了去年6月19號到現(xiàn)在的數(shù)據(jù)，整個(gè)過程10分鐘
8、drop表建議保留一段時(shí)間后再執(zhí)行 。

推薦閱讀