文档介绍：逻辑迁移
方案二、
采用expdp、impdp方法
使用并行 expdp
sqlplus as sysdba
SQL>create or replace directory export_DIR as '/home/new';tiger control=
控制文件() 将加载一个外部数据文件（含分隔符). :
load data
infile '/home/oracle/backup/script/'
replace into table emp
fields terminated by "," optionally enclosed by '"'
(empno,ename,job,mgr,hiredate date "dd-mon-yy",sal,comm,deptno)
如下:
7369,"Scott","CLERK",7902, 17-DEC-80, ,,20
7902,"FORD","ANALYST",7566, 17-DEC-80,,,20
7566,"JONES","MANAGER",7839, 17-DEC-80,,,20
7839,"KING","PRESIDENT", , 17-DEC-80,,,10
下面是一个指定记录长度的示例控制文件。"*" 代表数据文件与此文件同名，即在后面使用BEGINDATA段来标识数据。
load data
infile *
append
into table dept
FIELDS TERMINATED BY WHITESPACE OPTIONALLY ENCLOSED BY '"'
( deptno,
Dname,
LOC
)
begindata
90 "COMPUTER" "SCIENCE"
91 "ENGLISH" "LITERATURE"
92 "MATHEMATICS"
93 "POLITICAL" "SCIENCE"
Unloader这样的工具
Oracle 没有提供将数据导出到一个文件的工具。但是，我们可以用SQL*Plus的select 及 format 数据来输出到一个文件：
set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on
spool
select * from dept;
spool off
另外，也可以使用使用 UTL_FILE PL/SQL 包处理:
rem Remember to update , utl_file_dir='c:\oradata' parameter
declare
fp ;
begin
fp := ('c:\oradata','','w');
(fp, '%s, %s\n', 'TextField', 55);
(fp);
end;
/
当然你也可以使用第三方工具，如SQLWays ,TOAD for Quest等。
加载可变长度或指定长度的记录
如：
create table load_delimited_data(data1 integer,varchar(11));
LOAD DATA
INFILE *
INTO TABLE load_delimited_data
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( data1,
data2
)
BEGINDATA
11111,AAAAAAAAAA
22222,"A,B,C,D,"
下面是导入固定位置（固定长度）数据示例：
create table load_positional_data(data1 varchar(6),data2 varchar(11));
LOAD DATA
INFILE *
INTO TABLE load_positional_data
( data1 POSITION(1:5),
data2 POSITION(6:15)
)
BEGINDATA
111