impdp 多个表空间到1个表空间通配符的使用
linux下面使用通配符正常
impdp system/oracle directory=dump dumpfile=ht_%u remap_schema=ht:ht1 REMAP_TABLESPACE=%:ts_3 TABLE_EXISTS_ACTION=replace
[test]@ht01[/home/oracle]$impdp system/oracle directory=dump dumpfile=ht_%u remap_schema=ht:ht1 REMAP_TABLESPACE=%:ts_3 TABLE_EXISTS_ACTION=replace Import: Release 11.2.0.4.0 - Production on Tue Sep 10 06:40:15 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=dump dumpfile=ht_%u remap_schema=ht:ht1 REMAP_TABLESPACE=%:ts_3 TABLE_EXISTS_ACTION=replace Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "HT1"."A" 11.00 KB 4 rows . . imported "HT1"."B" 11.00 KB 4 rows Job "SYSTEM"."SYS_IMPORT_FULL_01" successfully completed at Tue Sep 10 06:40:16 2019 elapsed 0 00:00:01
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步