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 = ulcas

转载于:https://blog.51cto.com/clusty/288159