课程第36次（2017-06-06星期二）

botang

上完1Z0-053第19章
传送表空间三个实验（1. win32 AL32UTF8不能自包含出错；2. win32 AL32UTF8自包含；3. win32 ZHS16GBK只能导出表空间，不能传送表空间）
1Z0-052共19章（上完12章），1Z0-053共21章（上完13章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的25章

源头win32：
PL/SQL Developper连接utforcl库：

1. select   * from dba_data_files;
   
2. 
   
3. create tablespace tbsutforcl1 datafile 'C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\tbsutforcl1.dbf' size 10M ;
   
4. 
   
5. create table hr.tutforcl1( a  number )  tablespace tbsutforcl1  ;
   
6. 
   
7. insert into hr.tutforcl1 values ( 12345678) ;
   
8. 
   
9. create table sys.tutforcl3( a  number )  tablespace tbsutforcl1  ;
   
10. 
    
11. 
    
12. insert into sys.tutforcl3 values ( 12345678) ;
    
13. 
    
14. select  * from dba_segments s where s.tablespace_name='TBSUTFORCL1';
    
15. 
    
16. ----
    
17. begin
    
18.    dbms_tts.transport_set_check('TBSUTFORCL1');
    
19. end;
    
20. 
    
21. select  * from transport_set_violations;
    
22. 
    
23. alter table tutforcl3 move tablespace system;
    
24. 
    
25. 
    
26. alter tablespace tbsutforcl1 read only;
    
27. 
    
28. select  * from v$transportable_platform;
    
29. 
    
30. 
    
31. select  * from dba_directories;
    
32. 
    
33. 
    
34. select  * from dba_tablespaces;
    
35. 
    
36. alter tablespace tbsutforcl1 read write ;
    
37. 
    
38. 
    
39. ----
    
40. 
    
41. create tablespace tbsutforcl2 datafile 'C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\tbsutforcl2.dbf' size 10M ;
    
42. 
    
43. create table hr.tutforcl2( a  number )  tablespace tbsutforcl2  ;
    
44. 
    
45. insert into hr.tutforcl2 values ( 12345678) ;
    
46. 
    
47. select  * from dba_segments s where s.tablespace_name='TBSUTFORCL2';
    
48. 
    
49. alter tablespace tbsutforcl2 read only;
    
50. 
    
51. alter tablespace tbsutforcl2 read write ;
    

复制代码

PL/SQL Developper连接orcl库：

1. select   * from dba_data_files;
   
2. 
   
3. create tablespace tbsorcl datafile 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\tbsorcl.dbf' size 10M ;
   
4. 
   
5. create table hr.torcl( a  number )  tablespace tbsorcl  ;
   
6. 
   
7. insert into hr.torcl values ( 12345678) ;
   
8. 
   
9. select  * from dba_segments s where s.tablespace_name='TBSORCL';
   
10. 
    
11. alter tablespace tbsorcl read only ;
    
12. 
    
13. select  * from dba_directories;
    
14. 
    
15. create directory dir1 as 'c:\data';

复制代码

SQL*Plus：

1. 
   
2. ATA_OPTIONS
   
3. 数据层选项标记。
   
4. 有效的关键字值为: XML_CLOBS。
   
5. 
   
6. IRECTORY
   
7. 用于转储文件和日志文件的目录对象。
   
8. 
   
9. UMPFILE
   
10. 指定目标转储文件名的列表 [expdat.dmp]。
    
11. 例如, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp。
    
12. 
    
13. NCRYPTION
    
14. 加密某个转储文件的一部分或全部。
    
15. 有效的关键字值为: ALL, DATA_ONLY, ENCRYPTED_COLUMNS_ONLY, METADATA_ONLY 和 NONE
    
16. 。
    
17. 
    
18. NCRYPTION_ALGORITHM
    
19. 指定加密的方式。
    
20. 有效的关键字值为: [AES128], AES192 和 AES256。
    
21. 
    
22. NCRYPTION_MODE
    
23. 生成加密密钥的方法。
    
24. 有效的关键字值为: DUAL, PASSWORD 和 [TRANSPARENT]。
    
25. 
    
26. NCRYPTION_PASSWORD
    
27. 用于在转储文件中创建加密数据的口令密钥。
    
28. 
    
29. STIMATE
    
30. 计算作业估计值。
    
31. 有效的关键字值为: [BLOCKS] 和 STATISTICS。
    
32. 
    
33. STIMATE_ONLY
    
34. 计算作业估计值而不执行导出。
    
35. 
    
36. XCLUDE
    
37. 排除特定对象类型。
    
38. 例如, EXCLUDE=SCHEMA:"='HR'"。
    
39. 
    
40. ILESIZE
    
41. 以字节为单位指定每个转储文件的大小。
    
42. 
    
43. LASHBACK_SCN
    
44. 用于重置会话快照的 SCN。
    
45. 
    
46. LASHBACK_TIME
    
47. 用于查找最接近的相应 SCN 值的时间。
    
48. 
    
49. ULL
    
50. 导出整个数据库 [N]。
    
51. 
    
52. ELP
    
53. 显示帮助消息 [N]。
    
54. 
    
55. NCLUDE
    
56. 包括特定对象类型。
    
57. 例如, INCLUDE=TABLE_DATA。
    
58. 
    
59. OB_NAME
    
60. 要创建的导出作业的名称。
    
61. 
    
62. OGFILE
    
63. 指定日志文件名 [export.log]。
    
64. 
    
65. ETWORK_LINK
    
66. 源系统的远程数据库链接的名称。
    
67. 
    
68. OLOGFILE
    
69. 不写入日志文件 [N]。
    
70. 
    
71. ARALLEL
    
72. 更改当前作业的活动 worker 的数量。
    
73. 
    
74. ARFILE
    
75. 指定参数文件名。
    
76. 
    
77. UERY
    
78. 用于导出表的子集的谓词子句。
    
79. 例如, QUERY=employees:"WHERE department_id > 10"。
    
80. 
    
81. EMAP_DATA
    
82. 指定数据转换函数。
    
83. 例如, REMAP_DATA=EMP.EMPNO:REMAPPKG.EMPNO。
    
84. 
    
85. EUSE_DUMPFILES
    
86. 覆盖目标转储文件 (如果文件存在) [N]。
    
87. 
    
88. AMPLE
    
89. 要导出的数据的百分比。
    
90. 
    
91. CHEMAS
    
92. 要导出的方案的列表 [登录方案]。
    
93. 
    
94. OURCE_EDITION
    
95. 用于提取元数据的版本。
    
96. 
    
97. TATUS
    
98. 监视作业状态的频率, 其中
    
99. 默认值 [0] 表示只要有新状态可用, 就立即显示新状态。
    
100. 
     
101. ABLES
     
102. 标识要导出的表的列表。
     
103. 例如, TABLES=HR.EMPLOYEES,SH.SALES:SALES_1995。
     
104. 
     
105. ABLESPACES
     
106. 标识要导出的表空间的列表。
     
107. 
     
108. RANSPORTABLE
     
109. 指定是否可以使用可传输方法。
     
110. 有效的关键字值为: ALWAYS 和 [NEVER]。
     
111. 
     
112. RANSPORT_FULL_CHECK
     
113. 验证所有表的存储段 [N]。
     
114. 
     
115. RANSPORT_TABLESPACES
     
116. 要从中卸载元数据的表空间的列表。
     
117. 
     
118. ERSION
     
119. 要导出的对象版本。
     
120. 有效的关键字值为: [COMPATIBLE], LATEST 或任何有效的数据库版本。
     
121. 
     
122. -----------------------------------------------------------------------------
     
123. 
     
124. 下列命令在交互模式下有效。
     
125. 注: 允许使用缩写。
     
126. 
     
127. DD_FILE
     
128. 将转储文件添加到转储文件集。
     
129. 
     
130. ONTINUE_CLIENT
     
131. 返回到事件记录模式。如果处于空闲状态, 将重新启动作业。
     
132. 
     
133. XIT_CLIENT
     
134. 退出客户机会话并使作业保持运行状态。
     
135. 
     
136. ILESIZE
     
137. 用于后续 ADD_FILE 命令的默认文件大小 (字节)。
     
138. 
     
139. ELP
     
140. 汇总交互命令。
     
141. 
     
142. ILL_JOB
     
143. 分离并删除作业。
     
144. 
     
145. ARALLEL
     
146. 更改当前作业的活动 worker 的数量。
     
147. 
     
148. EUSE_DUMPFILES
     
149. 覆盖目标转储文件 (如果文件存在) [N]。
     
150. 
     
151. TART_JOB
     
152. 启动或恢复当前作业。
     
153. 有效的关键字值为: SKIP_CURRENT。
     
154. 
     
155. TATUS
     
156. 监视作业状态的频率, 其中
     
157. 默认值 [0] 表示只要有新状态可用, 就立即显示新状态。
     
158. 
     
159. TOP_JOB
     
160. 按顺序关闭作业执行并退出客户机。
     
161. 有效的关键字值为: IMMEDIATE。
     
162. 
     
163. 
     
164. 
     
165. :\Users\Administrator>expdp system/oracle_4U  directory=dir1  dumpfile=tbsutfor
     
166. l1.dmp  TRANSPORT_TABLESPACES=tbsutforcl1
     
167. 
     
168. xport: Release 11.2.0.1.0 - Production on 星期二 6月 6 21:03:13 2017
     
169. 
     
170. opyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
171. 
     
172. DE-28002: 操作产生了 ORACLE 错误 28002
     
173. RA-28002: 7 天之后口令将过期
     
174. 
     
175. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
     
176. ith the Partitioning, OLAP, Data Mining and Real Application Testing options
     
177. 启动 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dum
     
178. file=tbsutforcl1.dmp TRANSPORT_TABLESPACES=tbsutforcl1
     
179. 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
180. 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
     
181. 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
182. 已成功加载/卸载了主表 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"
     
183. *****************************************************************************
     
184. YSTEM.SYS_EXPORT_TRANSPORTABLE_01 的转储文件集为:
     
185. C:\DATA\TBSUTFORCL1.DMP
     
186. *****************************************************************************
     
187. 可传输表空间 TBSUTFORCL1 所需的数据文件:
     
188. C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TBSUTFORCL1.DBF
     
189. 作业 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" 已于 21:03:49 成功完成
     
190. 
     
191. 
     
192. :\Users\Administrator>expdp system/oracle_4U  directory=dir1  dumpfile=tbsutfor
     
193. l2.dmp  TRANSPORT_TABLESPACES=tbsutforcl2
     
194. 
     
195. xport: Release 11.2.0.1.0 - Production on 星期二 6月 6 21:21:50 2017
     
196. 
     
197. opyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
198. 
     
199. DE-28002: 操作产生了 ORACLE 错误 28002
     
200. RA-28002: 7 天之后口令将过期
     
201. 
     
202. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
     
203. ith the Partitioning, OLAP, Data Mining and Real Application Testing options
     
204. 启动 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dum
     
205. file=tbsutforcl2.dmp TRANSPORT_TABLESPACES=tbsutforcl2
     
206. 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
207. 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
     
208. 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
209. 已成功加载/卸载了主表 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"
     
210. *****************************************************************************
     
211. YSTEM.SYS_EXPORT_TRANSPORTABLE_01 的转储文件集为:
     
212. C:\DATA\TBSUTFORCL2.DMP
     
213. *****************************************************************************
     
214. 可传输表空间 TBSUTFORCL2 所需的数据文件:
     
215. C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\TBSUTFORCL2.DBF
     
216. 作业 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" 已于 21:22:23 成功完成
     
217. 
     
218. 
     
219. :\Users\Administrator>set ORACLE_SID=orcl
     
220. 
     
221. :\Users\Administrator>rman target /
     
222. 
     
223. 恢复管理器: Release 11.2.0.1.0 - Production on 星期二 6月 6 21:28:23 2017
     
224. 
     
225. opyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
226. 
     
227. 连接到目标数据库: ORCL (DBID=1347195613)
     
228. 
     
229. MAN> convert tablespace tbsorcl to platform 'Linux IA (64-bit)' format 'c:\data
     
230. %U';
     
231. 
     
232. 启动 conversion at source 于 06-6月 -17
     
233. 使用目标数据库控制文件替代恢复目录
     
234. 分配的通道: ORA_DISK_1
     
235. 通道 ORA_DISK_1: SID=17 设备类型=DISK
     
236. 通道 ORA_DISK_1: 启动数据文件转换
     
237. 输入数据文件: 文件号=00006 名称=C:\APP\ADMINISTRATOR\ORADATA\ORCL\TBSORCL.DBF
     
238. 已转换的数据文件 = C:\DATA\DATA_D-ORCL_I-1347195613_TS-TBSORCL_FNO-6_06S65516
     
239. 通道 ORA_DISK_1: 数据文件转换完毕, 经过时间: 00:00:01
     
240. 完成 conversion at source 于 06-6月 -17
     
241. 
     
242. MAN> exit
     
243. 
     
244. 
     
245. 恢复管理器完成。
     
246. 
     
247. :\Users\Administrator>expdp system/oracle_4U  directory=dir1  dumpfile=tbsorcl.
     
248. mp  TRANSPORT_TABLESPACES=tbsorcl
     
249. 
     
250. xport: Release 11.2.0.1.0 - Production on 星期二 6月 6 21:30:16 2017
     
251. 
     
252. opyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
253. 
     
254. DE-28002: 操作产生了 ORACLE 错误 28002
     
255. RA-28002: 7 天之后口令将过期
     
256. 
     
257. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
     
258. ith the Partitioning, OLAP, Data Mining and Real Application Testing options
     
259. 启动 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dum
     
260. file=tbsorcl.dmp TRANSPORT_TABLESPACES=tbsorcl
     
261. 处理对象类型 TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
262. 处理对象类型 TRANSPORTABLE_EXPORT/TABLE
     
263. 处理对象类型 TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
264. 已成功加载/卸载了主表 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"
     
265. *****************************************************************************
     
266. YSTEM.SYS_EXPORT_TRANSPORTABLE_01 的转储文件集为:
     
267. C:\DATA\TBSORCL.DMP
     
268. *****************************************************************************
     
269. 可传输表空间 TBSORCL 所需的数据文件:
     
270. C:\APP\ADMINISTRATOR\ORADATA\ORCL\TBSORCL.DBF
     
271. 作业 "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" 已于 21:30:54 成功完成
     
272. 
     
273. 
     
274. :\Users\Administrator>expdp system/oracle_4U  directory=dir1  dumpfile=tbsorcl.
     
275. mp  TABLESPACES=tbsorcl
     
276. 
     
277. xport: Release 11.2.0.1.0 - Production on 星期二 6月 6 21:34:11 2017
     
278. 
     
279. opyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
280. 
     
281. DE-28002: 操作产生了 ORACLE 错误 28002
     
282. RA-28002: 7 天之后口令将过期
     
283. 
     
284. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
     
285. ith the Partitioning, OLAP, Data Mining and Real Application Testing options
     
286. 启动 "SYSTEM"."SYS_EXPORT_TABLESPACE_01":  system/******** directory=dir1 dumpfi
     
287. e=tbsorcl.dmp TABLESPACES=tbsorcl
     
288. 正在使用 BLOCKS 方法进行估计...
     
289. 处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA
     
290. 使用 BLOCKS 方法的总估计: 64 KB
     
291. 处理对象类型 TABLE_EXPORT/TABLE/TABLE
     
292. . 导出了 "HR"."TORCL"                                5.007 KB       1 行
     
293. 已成功加载/卸载了主表 "SYSTEM"."SYS_EXPORT_TABLESPACE_01"
     
294. *****************************************************************************
     
295. YSTEM.SYS_EXPORT_TABLESPACE_01 的转储文件集为:
     
296. C:\DATA\TBSORCL.DMP
     
297. 作业 "SYSTEM"."SYS_EXPORT_TABLESPACE_01" 已于 21:34:17 成功完成
     
298. 
     
299. 
     
300. :\Users\Administrator>

复制代码

目的地linux64：
PL/SQL Developper：

1. select  * from v$log;
   
2. 
   
3. select  * from v$logfile;
   
4. 
   
5. alter database add logfile group 4 ('+data','+fra') size 52428800 blocksize 512;
   
6. 
   
7. select  * from dba_directories;
   
8. 
   
9. create directory dir1 as '/home/oracle/dir1';
   
10. 
    
11. select  * from dba_tablespaces;
    
12. 
    
13. select  * from hr.tutforcl1;
    
14. 
    
15. alter tablespace tbsutforcl1 read write ;
    
16. 
    
17. select  * from v$transportable_platform;
    
18. 
    
19. alter tablespace tbsutforcl2 read write ;
    
20. 
    
21. select  * from hr.tutforcl2;
    
22. 
    
23. select  * from hr.torcl;
    
24. 
    
25. select  * from dba_tables t where t.table_name='TORCL' and t.owner='HR';
    
26. 
    
27. 
    

复制代码

SQL*Plus：

1. [root@station90 ~]# su - oracle
   
2. [oracle@station90 ~]$ cd /u01/app/
   
3. [oracle@station90 app]$ ls
   
4. oracle  oraInventory
   
5. [oracle@station90 app]$ cd oracle/
   
6. [oracle@station90 oracle]$ ls
   
7. admin  cfgtoollogs  checkpoints  diag  flash_recovery_area  man_recovery_area  man_recovery_area.11g  oradata  product
   
8. [oracle@station90 oracle]$ cd oradata/
   
9. [oracle@station90 oradata]$ ls
   
10. rcat
    
11. [oracle@station90 oradata]$ mkdir orcl
    
12. [oracle@station90 oradata]$ cd orcl/
    
13. [oracle@station90 orcl]$ ls
    
14. [oracle@station90 orcl]$ pwd
    
15. /u01/app/oracle/oradata/orcl
    
16. [oracle@station90 orcl]$ ls
    
17. DATA_D-UTFORCL_I-454057935_TS-TBSUTFORCL1_FNO-7_01S653C2
    
18. [oracle@station90 orcl]$ mv DATA_D-UTFORCL_I-454057935_TS-TBSUTFORCL1_FNO-7_01S653C2 tbsutforcl1.dbf  
    
19. [oracle@station90 orcl]$ ls
    
20. tbsutforcl1.dbf
    
21. [oracle@station90 orcl]$ pwd
    
22. /u01/app/oracle/oradata/orcl
    
23. [oracle@station90 orcl]$ cd
    
24. [oracle@station90 ~]$ ls
    
25. copytape-root.sh         mail            rac_tns                  tnsnames.ora              update_t04209_uname.sql  视频  下载
    
26. create_t04209_uname.sql  oradiag_oracle  revertape-root.sh        ttio.rcv                  公共的                   图片  音乐
    
27. dir1                     osb.txt         select_t04209_uname.sql  update2_t04209_uname.sql  模板                     文档  桌面
    
28. [oracle@station90 ~]$ exit
    
29. logout
    
30. [root@station90 ~]# chown oracle:oinstall /home/oracle/dir1/TBSUTFORCL1.DMP
    
31. [root@station90 ~]# su - oracle
    
32. [oracle@station90 ~]$ impdp help=y
    
33. 
    
34. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:08:28 2017
    
35. 
    
36. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
37. 
    
38. 
    
39. The Data Pump Import utility provides a mechanism for transferring data objects
    
40. between Oracle databases. The utility is invoked with the following command:
    
41. 
    
42.      Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
    
43. 
    
44. You can control how Import runs by entering the 'impdp' command followed
    
45. by various parameters. To specify parameters, you use keywords:
    
46. 
    
47.      Format:  impdp KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
    
48.      Example: impdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp
    
49. 
    
50. USERID must be the first parameter on the command line.
    
51. 
    
52. ------------------------------------------------------------------------------
    
53. 
    
54. The available keywords and their descriptions follow. Default values are listed within square brackets.
    
55. 
    
56. ATTACH
    
57. Attach to an existing job.
    
58. For example, ATTACH=job_name.
    
59. 
    
60. CONTENT
    
61. Specifies data to load.
    
62. Valid keywords are: [ALL], DATA_ONLY and METADATA_ONLY.
    
63. 
    
64. DATA_OPTIONS
    
65. Data layer option flags.
    
66. Valid keywords are: SKIP_CONSTRAINT_ERRORS.
    
67. 
    
68. DIRECTORY
    
69. Directory object to be used for dump, log and sql files.
    
70. 
    
71. DUMPFILE
    
72. List of dumpfiles to import from [expdat.dmp].
    
73. For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
    
74. 
    
75. ENCRYPTION_PASSWORD
    
76. Password key for accessing encrypted data within a dump file.
    
77. Not valid for network import jobs.
    
78. 
    
79. ESTIMATE
    
80. Calculate job estimates.
    
81. Valid keywords are: [BLOCKS] and STATISTICS.
    
82. 
    
83. EXCLUDE
    
84. Exclude specific object types.
    
85. For example, EXCLUDE=SCHEMA:"='HR'".
    
86. 
    
87. FLASHBACK_SCN
    
88. SCN used to reset session snapshot.
    
89. 
    
90. FLASHBACK_TIME
    
91. Time used to find the closest corresponding SCN value.
    
92. 
    
93. FULL
    
94. Import everything from source [Y].
    
95. 
    
96. HELP
    
97. Display help messages [N].
    
98. 
    
99. INCLUDE
    
100. Include specific object types.
     
101. For example, INCLUDE=TABLE_DATA.
     
102. 
     
103. JOB_NAME
     
104. Name of import job to create.
     
105. 
     
106. LOGFILE
     
107. Log file name [import.log].
     
108. 
     
109. NETWORK_LINK
     
110. Name of remote database link to the source system.
     
111. 
     
112. NOLOGFILE
     
113. Do not write log file [N].
     
114. 
     
115. PARALLEL
     
116. Change the number of active workers for current job.
     
117. 
     
118. PARFILE
     
119. Specify parameter file.
     
120. 
     
121. PARTITION_OPTIONS
     
122. Specify how partitions should be transformed.
     
123. Valid keywords are: DEPARTITION, MERGE and [NONE].
     
124. 
     
125. QUERY
     
126. Predicate clause used to import a subset of a table.
     
127. For example, QUERY=employees:"WHERE department_id > 10".
     
128. 
     
129. REMAP_DATA
     
130. Specify a data conversion function.
     
131. For example, REMAP_DATA=EMP.EMPNO:REMAPPKG.EMPNO.
     
132. 
     
133. REMAP_DATAFILE
     
134. Redefine datafile references in all DDL statements.
     
135. 
     
136. REMAP_SCHEMA
     
137. Objects from one schema are loaded into another schema.
     
138. 
     
139. REMAP_TABLE
     
140. Table names are remapped to another table.
     
141. For example, REMAP_TABLE=EMP.EMPNO:REMAPPKG.EMPNO.
     
142. 
     
143. REMAP_TABLESPACE
     
144. Tablespace object are remapped to another tablespace.
     
145. 
     
146. REUSE_DATAFILES
     
147. Tablespace will be initialized if it already exists [N].
     
148. 
     
149. SCHEMAS
     
150. List of schemas to import.
     
151. 
     
152. SKIP_UNUSABLE_INDEXES
     
153. Skip indexes that were set to the Index Unusable state.
     
154. 
     
155. SOURCE_EDITION
     
156. Edition to be used for extracting metadata.
     
157. 
     
158. SQLFILE
     
159. Write all the SQL DDL to a specified file.
     
160. 
     
161. STATUS
     
162. Frequency (secs) job status is to be monitored where
     
163. the default [0] will show new status when available.
     
164. 
     
165. STREAMS_CONFIGURATION
     
166. Enable the loading of Streams metadata
     
167. 
     
168. TABLE_EXISTS_ACTION
     
169. Action to take if imported object already exists.
     
170. Valid keywords are: APPEND, REPLACE, [SKIP] and TRUNCATE.
     
171. 
     
172. TABLES
     
173. Identifies a list of tables to import.
     
174. For example, TABLES=HR.EMPLOYEES,SH.SALES:SALES_1995.
     
175. 
     
176. TABLESPACES
     
177. Identifies a list of tablespaces to import.
     
178. 
     
179. TARGET_EDITION
     
180. Edition to be used for loading metadata.
     
181. 
     
182. TRANSFORM
     
183. Metadata transform to apply to applicable objects.
     
184. Valid keywords are: OID, PCTSPACE, SEGMENT_ATTRIBUTES and STORAGE.
     
185. 
     
186. TRANSPORTABLE
     
187. Options for choosing transportable data movement.
     
188. Valid keywords are: ALWAYS and [NEVER].
     
189. Only valid in NETWORK_LINK mode import operations.
     
190. 
     
191. TRANSPORT_DATAFILES
     
192. List of datafiles to be imported by transportable mode.
     
193. 
     
194. TRANSPORT_FULL_CHECK
     
195. Verify storage segments of all tables [N].
     
196. 
     
197. TRANSPORT_TABLESPACES
     
198. List of tablespaces from which metadata will be loaded.
     
199. Only valid in NETWORK_LINK mode import operations.
     
200. 
     
201. VERSION
     
202. Version of objects to import.
     
203. Valid keywords are: [COMPATIBLE], LATEST or any valid database version.
     
204. Only valid for NETWORK_LINK and SQLFILE.
     
205. 
     
206. ------------------------------------------------------------------------------
     
207. 
     
208. The following commands are valid while in interactive mode.
     
209. Note: abbreviations are allowed.
     
210. 
     
211. CONTINUE_CLIENT
     
212. Return to logging mode. Job will be restarted if idle.
     
213. 
     
214. EXIT_CLIENT
     
215. Quit client session and leave job running.
     
216. 
     
217. HELP
     
218. Summarize interactive commands.
     
219. 
     
220. KILL_JOB
     
221. Detach and delete job.
     
222. 
     
223. PARALLEL
     
224. Change the number of active workers for current job.
     
225. 
     
226. START_JOB
     
227. Start or resume current job.
     
228. Valid keywords are: SKIP_CURRENT.
     
229. 
     
230. STATUS
     
231. Frequency (secs) job status is to be monitored where
     
232. the default [0] will show new status when available.
     
233. 
     
234. STOP_JOB
     
235. Orderly shutdown of job execution and exits the client.
     
236. Valid keywords are: IMMEDIATE.
     
237. 
     
238. 
     
239. [oracle@station90 ~]$ impdp system/oracle_4U  directory=dir1 dumpfile=TBSUTFORCL1.DMP TRANSPORT_DATAFILES='/u01/app/oracle/oradata/orcl/tbsutforcl1.dbf'
     
240. 
     
241. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:09:53 2017
     
242. 
     
243. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
244. 
     
245. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
246. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
247. and Real Application Testing options
     
248. Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
     
249. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=TBSUTFORCL1.DMP TRANSPORT_DATAFILES=/u01/app/oracle/oradata/orcl/tbsutforcl1.dbf
     
250. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
251. Processing object type TRANSPORTABLE_EXPORT/TABLE
     
252. Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
253. Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 21:09:58
     
254. 
     
255. [oracle@station90 ~]$ impdp system/oracle_4U  directory=dir1 dumpfile=TBSUTFORCL2.DMP TRANSPORT_DATAFILES='/u01/app/oracle/oradata/orcl/tbsutforcl2.dbf'  
     
256. 
     
257. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:23:25 2017
     
258. 
     
259. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
260. 
     
261. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
262. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
263. and Real Application Testing options
     
264. Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
     
265. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=TBSUTFORCL2.DMP TRANSPORT_DATAFILES=/u01/app/oracle/oradata/orcl/tbsutforcl2.dbf
     
266. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
267. ORA-39123: Data Pump transportable tablespace job aborted
     
268. ORA-19722: datafile /u01/app/oracle/oradata/orcl/tbsutforcl2.dbf is an incorrect version
     
269. 
     
270. Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 21:23:27
     
271. 
     
272. [oracle@station90 ~]$ impdp system/oracle_4U  directory=dir1 dumpfile=TBSUTFORCL2.DMP TRANSPORT_DATAFILES='/u01/app/oracle/oradata/orcl/tbsutforcl2.dbf'  
     
273. 
     
274. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:26:07 2017
     
275. 
     
276. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
277. 
     
278. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
279. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
280. and Real Application Testing options
     
281. Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
     
282. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=TBSUTFORCL2.DMP TRANSPORT_DATAFILES=/u01/app/oracle/oradata/orcl/tbsutforcl2.dbf
     
283. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
284. Processing object type TRANSPORTABLE_EXPORT/TABLE
     
285. Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
     
286. Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 21:26:08
     
287. 
     
288. [oracle@station90 ~]$ impdp system/oracle_4U  directory=dir1 dumpfile=TBSORCL.DMP TRANSPORT_DATAFILES='/u01/app/oracle/oradata/orcl/tbsorcl.dbf'  
     
289. 
     
290. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:32:59 2017
     
291. 
     
292. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
293. 
     
294. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
295. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
296. and Real Application Testing options
     
297. Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
     
298. Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** directory=dir1 dumpfile=TBSORCL.DMP TRANSPORT_DATAFILES=/u01/app/oracle/oradata/orcl/tbsorcl.dbf
     
299. Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
     
300. ORA-39123: Data Pump transportable tablespace job aborted
     
301. ORA-29345: cannot plug a tablespace into a database using an incompatible character set
     
302. 
     
303. Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 21:33:00
     
304. 
     
305. [oracle@station90 ~]$ impdp system/oracle_4U  directory=dir1 dumpfile=TBSORCL.DMP
     
306. 
     
307. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:36:04 2017
     
308. 
     
309. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
310. 
     
311. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
312. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
313. and Real Application Testing options
     
314. Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
     
315. Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=dir1 dumpfile=TBSORCL.DMP
     
316. Processing object type TABLE_EXPORT/TABLE/TABLE
     
317. ORA-39083: Object type TABLE:"HR"."TORCL" failed to create with error:
     
318. ORA-00959: tablespace 'TBSORCL' does not exist
     
319. Failing sql is:
     
320. CREATE TABLE "HR"."TORCL" ("A" NUMBER) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "TBSORCL"
     
321. 
     
322. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
     
323. Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 21:36:05
     
324. 
     
325. [oracle@station90 ~]$ impdp system/oracle_4U  directory=dir1 dumpfile=TBSORCL.DMP remap_tablespace=TBSORCL:users
     
326. 
     
327. Import: Release 11.2.0.1.0 - Production on Tue Jun 6 21:36:57 2017
     
328. 
     
329. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
330. 
     
331. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
332. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
333. and Real Application Testing options
     
334. Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
     
335. Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=dir1 dumpfile=TBSORCL.DMP remap_tablespace=TBSORCL:users
     
336. Processing object type TABLE_EXPORT/TABLE/TABLE
     
337. Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
     
338. . . imported "HR"."TORCL"                                5.007 KB       1 rows
     
339. Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at 21:36:58
     
340. 
     
341. [oracle@station90 ~]$
     

复制代码