--用外部表(ORACLE_DATAPUMP)导出数据到文件再导入实验
--只有ORACLE_DATAPUMP引擎支持这种方式
--创建外部表来导出数据
SYS@PROD1> create table scott.dept_emp organization external
2 (
3 type oracle_datapump
4 default directory ext
5 location('dept_dp.data')
6 )
7 as
8 select * from scott.dept;
Table created.
SYS@PROD1> select * from scott.dept_emp;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
[oracle@ocm1 ~]$ cd /home/oracle/ext/
[oracle@ocm1 ext]$ ls dept_dp.data
dept_dp.data
--创建外部表来导入数据
SYS@PROD1> create table eoda.extbk
2 ( deptno number(2),
3 dname varchar2(14),
4 loc varchar2(13)
5 )
6 organization external
7 (type oracle_datapump
8 default directory ext
9 location('dep