数据迁移方法教案编写 .pptVIP

单元目标;数据迁移方法;数据导入导出工具一览;DEL格式;非DEL的ACSII格式;PC/IXF格式;INSERT 语句;IMPORT 命令语法(Basic);IMPORT 大对象处理;IMPORT modified by修饰符;IMPORT 和 LOAD 对比;Load 过程的4个阶段;LOAD 命令语法(Basic);LOAD 典型场景;创建异常表(Exception Tables);离线/在线加载 (Offline versus Online Load);表状态(Table states);Load Pending状态: 从LOAD 失败中恢复;对于归档日志模式的数据库，有三种Load选项： COPY NO (default) During load, Backup pending and Load in progress After load, Backup Pending COPY YES Load has made Copy not Backup pending NONRECOVERABLE No copy made and no backup required;Set Integrity Pending表状态;SET INTEGRITY 命令语法;Set Integrity Pending state;Set Integrity Pending