Oracle数据库命令速查手册-LOAD数据

1.loading data using direct_load insert 
sql> insert /*+append */ into emp nologging 
sql> select * from emp_old; 
2.parallel direct-load insert 
sql> alter session enable parallel dml; 
sql> insert /*+parallel(emp,2) */ into emp nologging 
sql> select * from emp_old; 
3.using sql*loader 
sql> sqlldr scott/tiger \ 
sql> control = ulcase6.ctl \ 
sql> log = ulcase6.log direct=true