数据泵外部表(带并行度)
导出:create table ext2
organization external
( type oracle_datapump
default directory dir1
location ( DIR1:'ext2a.dmp', DIR2:'ext2b.dmp'))
parallel 2
as
select e.employee_id, e.last_name, e.salary, d.department_name
from employees e full outer join departments d
on (e.department_id = d.department_id) ;导入:
$ strings ext2a.dmp
"HR"."U"
x86_64/Linux 2.4.xx
AL32UTF8
12.01.00.02.00
001:001:000001:000001
i<?xml version="1.0"?>
<ROWSET>
<ROW>
<STRMTABLE_T>
<VERS_MAJOR>1</VERS_MAJOR>
<VERS_MINOR>0 </VERS_MINOR>
<VERS_DPAPI>3</VERS_DPAPI>
<ENDIANNESS>0</ENDIANNESS>
<CHARSET>AL32UTF8</CHARSET>
<NCHARSET>AL16UTF16</NCHARSET>
<DBTIMEZONE>+00:00</DBTIMEZONE>
<OWNER_NAME>HR</OWNER_NAME>
<NAME>EXT2</NAME>
<COL_LIST>
<COL_LIST_ITEM>
<COL_NUM>1</COL_NUM>
<NAME>EMPLOYEE_ID</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<PRECISION_NUM>6</PRECISION_NUM>
<SCALE>0</SCALE>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<CHARLENGTH>0</CHARLENGTH>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<COL_NUM>2</COL_NUM>
<NAME>LAST_NAME</NAME>
<TYPE_NUM>1</TYPE_NUM>
<LENGTH>25</LENGTH>
<PRECISION_NUM>0</PRECISION_NUM>
<SCALE>0</SCALE>
<CHARSETID>873</CHARSETID>
<CHARSETFORM>1</CHARSETFORM>
<CHARLENGTH>25</CHARLENGTH>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<COL_NUM>3</COL_NUM>
<NAME>SALARY</NAME>
<TYPE_NUM>2</TYPE_NUM>
<LENGTH>22</LENGTH>
<PRECISION_NUM>8</PRECISION_NUM>
<SCALE>2</SCALE>
<CHARSETID>0</CHARSETID>
<CHARSETFORM>0</CHARSETFORM>
<CHARLENGTH>0</CHARLENGTH>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
<COL_NUM>4</COL_NUM>
<NAME>DEPARTMENT_NAME</NAME>
<TYPE_NUM>1</TYPE_NUM>
<LENGTH>30</LENGTH>
<PRECISION_NUM>0</PRECISION_NUM>
<SCALE>0</SCALE>
<CHARSETID>873</CHARSETID>
<CHARSETFORM>1</CHARSETFORM>
<CHARLENGTH>30</CHARLENGTH>
</COL_LIST_ITEM>
</COL_LIST>
</STRMTABLE_T>
</ROW>
</ROWSET>
Hunold
Ernst
Austin
Pataballa
Lorentz
Greenberg
Finance<
Faviet
Finance<
Chen
Finance<
Sciarra
Finance<
Urman
Finance<
Popp
Finance<
Raphaely
Purchasing<
Khoo
Purchasing<
Baida
Purchasing<
Tobias
Purchasing<
Himuro
Purchasing<
Colmenares
Purchasing<
Weiss
Shipping<
Fripp
Shipping<
Kaufling
Shipping<
Vollman
Shipping<
Mourgos
Shipping<
Nayer
Shipping<
Mikkilineni
Shipping<
Landry
Shipping<
Markle
Shipping<
Bissot
Shipping<
Atkinson
Shipping<
Marlow
Shipping<
Olson
Shipping<
Mallin
Shipping<
Rogers
Shipping<
Shipping<
Philtanker
Shipping<
Ladwig
Shipping<
Stiles
Shipping<
Shipping<
Patel
Shipping<
Rajs
Shipping<
Davies
Shipping<
Matos
Shipping<
Vargas
Shipping<
Russell
Sales<
Partners
Sales<
0 Errazuriz
Sales<
1 Cambrault
Sales<
Zlotkey
Sales<
Tucker
Sales<
4 Bernstein
Sales<
Hall
Sales<
Olsen
Sales<
7 Cambrault
Sales<
Tuvault
Sales<
King
Sales<
Sully
Sales<
McEwen
Sales<
Smith
Sales<
Doran
Sales<
Sewall
Sales<
Vishney
Sales<
Greene
Sales<
Marvins
Sales<
Sales<
Ande
Sales<
Banda
Sales<
Ozer
Sales<
Bloom
Sales<
Sales<
Smith
Sales<
Bates
Sales<
Kumar
Sales<
Abel
Sales<
Hutton
Sales<
Taylor
Sales<
Livingston
Sales<
Johnson
Sales<
Taylor
Shipping<
Fleaur
Shipping<
Sullivan
Shipping<
Geoni
Shipping<
Sarchand
Shipping<
Bull
Shipping<
W Dellinger
Shipping<
Cabrio
Shipping<
Chung
Shipping<
Dilly
Shipping<
Gates
Shipping<
Perkins
Shipping<
Bell
Shipping<
Everett
Shipping<
McCain
Shipping<
Jones
Shipping<
Walsh
Shipping<
Feeney
Shipping<
OConnell
Shipping<
Grant
Shipping<
Baer
Public Relations<
NOC<
Manufacturing<
Recruiting<
Operations<
Shareholder Services<
Construction<
Contracting
$
orcl2:
create table ext3(EMPLOYEE_ID number(22,6),
LAST_NAMEvarchar2(25) ,
SALARY number(22,8) ,
DEPARTMENT_NAMEvarchar2(30)
)
organization external
( type oracle_datapump
default directory dir1
location ( DIR1:'ext2a.dmp', DIR2:'ext2b.dmp'))
parallel 2;
页:
[1]