数据泵外部表（带并行度）

botang

导出：

1. create table ext2
   
2. organization external
   
3. ( type oracle_datapump
   
4.   default directory dir1
   
5.   location ( DIR1:'ext2a.dmp', DIR2:'ext2b.dmp'))
   
6. parallel 2
   
7. as
   
8. select e.employee_id, e.last_name, e.salary, d.department_name
   
9. from employees e   full outer join departments d
   
10. on (e.department_id = d.department_id) ;

复制代码

导入：

1. [oracle@classroom orcl2]$ strings ext2a.dmp
   
2. "HR"."U"
   
3. x86_64/Linux 2.4.xx
   
4. AL32UTF8
   
5. 12.01.00.02.00
   
6. 001:001:000001:000001
   
7. i<?xml version="1.0"?>
   
8. <ROWSET>
   
9. <ROW>
   
10.   <STRMTABLE_T>
    
11.    <VERS_MAJOR>1</VERS_MAJOR>
    
12.    <VERS_MINOR>0 </VERS_MINOR>
    
13.    <VERS_DPAPI>3</VERS_DPAPI>
    
14.    <ENDIANNESS>0</ENDIANNESS>
    
15.    <CHARSET>AL32UTF8</CHARSET>
    
16.    <NCHARSET>AL16UTF16</NCHARSET>
    
17.    <DBTIMEZONE>+00:00</DBTIMEZONE>
    
18.    <OWNER_NAME>HR</OWNER_NAME>
    
19.    <NAME>EXT2</NAME>
    
20.    <COL_LIST>
    
21.      <COL_LIST_ITEM>
    
22.       <COL_NUM>1</COL_NUM>
    
23.       <NAME>EMPLOYEE_ID</NAME>
    
24.       <TYPE_NUM>2</TYPE_NUM>
    
25.       <LENGTH>22</LENGTH>
    
26.       <PRECISION_NUM>6</PRECISION_NUM>
    
27.       <SCALE>0</SCALE>
    
28.       <CHARSETID>0</CHARSETID>
    
29.       <CHARSETFORM>0</CHARSETFORM>
    
30.       <CHARLENGTH>0</CHARLENGTH>
    
31.      </COL_LIST_ITEM>
    
32.      <COL_LIST_ITEM>
    
33.       <COL_NUM>2</COL_NUM>
    
34.       <NAME>LAST_NAME</NAME>
    
35.       <TYPE_NUM>1</TYPE_NUM>
    
36.       <LENGTH>25</LENGTH>
    
37.       <PRECISION_NUM>0</PRECISION_NUM>
    
38.       <SCALE>0</SCALE>
    
39.       <CHARSETID>873</CHARSETID>
    
40.       <CHARSETFORM>1</CHARSETFORM>
    
41.       <CHARLENGTH>25</CHARLENGTH>
    
42.      </COL_LIST_ITEM>
    
43.      <COL_LIST_ITEM>
    
44.       <COL_NUM>3</COL_NUM>
    
45.       <NAME>SALARY</NAME>
    
46.       <TYPE_NUM>2</TYPE_NUM>
    
47.       <LENGTH>22</LENGTH>
    
48.       <PRECISION_NUM>8</PRECISION_NUM>
    
49.       <SCALE>2</SCALE>
    
50.       <CHARSETID>0</CHARSETID>
    
51.       <CHARSETFORM>0</CHARSETFORM>
    
52.       <CHARLENGTH>0</CHARLENGTH>
    
53.      </COL_LIST_ITEM>
    
54.      <COL_LIST_ITEM>
    
55.       <COL_NUM>4</COL_NUM>
    
56.       <NAME>DEPARTMENT_NAME</NAME>
    
57.       <TYPE_NUM>1</TYPE_NUM>
    
58.       <LENGTH>30</LENGTH>
    
59.       <PRECISION_NUM>0</PRECISION_NUM>
    
60.       <SCALE>0</SCALE>
    
61.       <CHARSETID>873</CHARSETID>
    
62.       <CHARSETFORM>1</CHARSETFORM>
    
63.       <CHARLENGTH>30</CHARLENGTH>
    
64.      </COL_LIST_ITEM>
    
65.    </COL_LIST>
    
66.   </STRMTABLE_T>
    
67. </ROW>
    
68. </ROWSET>
    
69. Hunold
    
70. Ernst
    
71. Austin
    
72.         Pataballa
    
73. Lorentz
    
74.                 Greenberg
    
75. Finance<
    
76. Faviet
    
77. Finance<
    
78. Chen
    
79. Finance<
    
80. Sciarra
    
81. Finance<
    
82. Urman
    
83. Finance<
    
84. Popp
    
85. Finance<
    
86. Raphaely
    
87. Purchasing<
    
88. Khoo
    
89. Purchasing<
    
90. Baida
    
91. Purchasing<
    
92. Tobias
    
93. Purchasing<
    
94. Himuro
    
95. Purchasing<
    
96. Colmenares
    
97. Purchasing<
    
98. Weiss
    
99. Shipping<
    
100. Fripp
     
101. Shipping<
     
102. Kaufling
     
103. Shipping<
     
104. Vollman
     
105. Shipping<
     
106. Mourgos
     
107. Shipping<
     
108. Nayer
     
109. Shipping<
     
110. Mikkilineni
     
111. Shipping<
     
112. Landry
     
113. Shipping<
     
114. Markle
     
115. Shipping<
     
116. Bissot
     
117. Shipping<
     
118. Atkinson
     
119. Shipping<
     
120. Marlow
     
121. Shipping<
     
122. Olson
     
123. Shipping<
     
124. Mallin
     
125. Shipping<
     
126. Rogers
     
127. Shipping<
     
128. Shipping<
     
129. Philtanker
     
130. Shipping<
     
131. Ladwig
     
132. Shipping<
     
133. Stiles
     
134. Shipping<
     
135. Shipping<
     
136. Patel
     
137. Shipping<
     
138. Rajs
     
139. Shipping<
     
140. Davies
     
141. Shipping<
     
142. Matos
     
143. Shipping<
     
144. Vargas
     
145. Shipping<
     
146. Russell
     
147. Sales<
     
148. Partners
     
149. Sales<
     
150. 0        Errazuriz
     
151. Sales<
     
152. 1        Cambrault
     
153. Sales<
     
154. Zlotkey
     
155. Sales<
     
156. Tucker
     
157. Sales<
     
158. 4        Bernstein
     
159. Sales<
     
160. Hall
     
161. Sales<
     
162. Olsen
     
163. Sales<
     
164. 7        Cambrault
     
165. Sales<
     
166. Tuvault
     
167. Sales<
     
168. King
     
169. Sales<
     
170. Sully
     
171. Sales<
     
172. McEwen
     
173. Sales<
     
174. Smith
     
175. Sales<
     
176. Doran
     
177. Sales<
     
178. Sewall
     
179. Sales<
     
180. Vishney
     
181. Sales<
     
182. Greene
     
183. Sales<
     
184. Marvins
     
185. Sales<
     
186. Sales<
     
187. Ande
     
188. Sales<
     
189. Banda
     
190. Sales<
     
191. Ozer
     
192. Sales<
     
193. Bloom
     
194. Sales<
     
195. Sales<
     
196. Smith
     
197. Sales<
     
198. Bates
     
199. Sales<
     
200. Kumar
     
201. Sales<
     
202. Abel
     
203. Sales<
     
204. Hutton
     
205. Sales<
     
206. Taylor
     
207. Sales<
     
208. Livingston
     
209. Sales<
     
210. Johnson
     
211. Sales<
     
212. Taylor
     
213. Shipping<
     
214. Fleaur
     
215. Shipping<
     
216. Sullivan
     
217. Shipping<
     
218. Geoni
     
219. Shipping<
     
220. Sarchand
     
221. Shipping<
     
222. Bull
     
223. Shipping<
     
224. W        Dellinger
     
225. Shipping<
     
226. Cabrio
     
227. Shipping<
     
228. Chung
     
229. Shipping<
     
230. Dilly
     
231. Shipping<
     
232. Gates
     
233. Shipping<
     
234. Perkins
     
235. Shipping<
     
236. Bell
     
237. Shipping<
     
238. Everett
     
239. Shipping<
     
240. McCain
     
241. Shipping<
     
242. Jones
     
243. Shipping<
     
244. Walsh
     
245. Shipping<
     
246. Feeney
     
247. Shipping<
     
248. OConnell
     
249. Shipping<
     
250. Grant
     
251. Shipping<
     
252. Baer
     
253. Public Relations<
     
254. NOC<
     
255. Manufacturing<
     
256. Recruiting<
     
257. Operations<
     
258. Shareholder Services<
     
259. Construction<
     
260. Contracting
     
261. [oracle@classroom orcl2]$
     

复制代码

orcl2:

1. create table ext3(EMPLOYEE_ID number(22,6)  ,
   
2. LAST_NAME  varchar2(25) ,
   
3. SALARY number(22,8) ,
   
4. DEPARTMENT_NAME  varchar2(30)
   
5. )
   
6. organization external
   
7. ( type oracle_datapump
   
8.   default directory dir1
   
9.   location ( DIR1:'ext2a.dmp', DIR2:'ext2b.dmp'))
   
10. parallel 2;

复制代码