SQL> create or replace directory tmp as '/tmp'
SQL> create table vehiclealarm_external
organization external
(type oracle_datapump
default directory tmp
location('vehiclealarm.dat')
)
as select * from vehiclealarm;
insert /*+append */ into vehiclealarm as select * from vehiclealarm_external
如果vehiclealarm_1.dat,vehiclealarm_2.dat,vehiclealarm_3.dat,
可以改变文件的存放路径
alter table vehiclealarm_external
location( 'vehiclealarm_1.dat','vehiclealarm_2.dat','vehiclealarm_3.dat')
如果把表vehiclealarm迁移到vehiclealarm2中,可以通过
insert /*+append */ into vehiclealarm2 as select * from vehiclealarm
在非归档模式下通过insert /*+ append */ into方式批量加载数据可以大大减少redo产生.
在归档模式下,需要使表处于nologging状态。alter table vehiclealarm2 nologging,再用insert/* +append */来进行操作。
操作完成以后使用 alter table vehiclealarm2 logging;然后数据库做一个全备份