导入导出
exp system/123456@WWW file=d:\xxx.dmp
imp system/123456@WWW FROMUSER=system TOUSER=system file=d:\xxx.dmp
修改表结构
alter table user.tb1 ADD(type number(1) default 0);
alter table user.tb2 modify(intro varchar2(650))
重建索引
DROP SEQUENCE tb1.article_seq;
CREATE SEQUENCE tb1.article_seq; INCREMENT BY 1 START WITH 24 NOCYCLE NOCACHE;
修改varchar2为clob
ALTER TABLE user.tb1 ADD (duties1 CLOB);
UPDATE user.tb1 SET duties1=duties;
ALTER TABLE user.tb1 DROP COLUMN duties;
ALTER TABLE user.tb1 RENAME COLUMN duties1 TO duties;