1、direct load types:serial, parallel
2、串行:insert /*+ append */ into emp nologging select * from t_employees
数据直接插入hwm后面,速度最快,块对块拷贝,commit后才可查询
3、并行:alter session enable parallel dml;
insert /*+ parallel(hr.employees,2) */ into emp nologging select * from t_employees
4、nologging 不起作用,需 alter table emp nologging, 不产生redo,undo,插入数据成功后要立即备份数据
5、sql*loader:control file ,data file
6、字符集转换:目的字符需要是源的超集,否则可能数据丢失