备份oracle中的大表

2019独角兽企业重金招聘Python工程师标准>>>

1. 将原标进行rename操作：RENAME loganalysis to loganalysis_bak;

2. 压缩备份表：alter table LOGANALYSIS_bak move compress;

3. 查看备份表的索引字段：SELECT * from user_cons_columns where TABLE_NAME='LOGANALYSIS_BAK';

4. 清除备份表的索引：alter table LOGANALYSIS_BAK drop constraint SYS_C005697;

5. 查看备份表建表语句：select dbms_metadata.get_ddl('TABLE','LOGANALYSIS_BAK') from dual;

6. 创建新表

7. 创建新表索引：alter table LOGANALYSIS add constraint PK_LOGANALYSIS primary key(id);

转载于:https://my.oschina.net/hanjiafu/blog/526631