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=replaceimport: Release 11.2.0.4.0 - Production on Tue Sep 10 06:40:15 2019copyright (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 ProductionWith the Partitioning,olAP,Data Mining and Real Application Testing optionsMaster table "SYstem"."SYS_import_FulL_01" successfully loaded/unloadedStarting "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/USERProcessing object type SCHEMA_EXPORT/SYstem_GRANTProcessing object type SCHEMA_EXPORT/RolE_GRANTProcessing object type SCHEMA_EXPORT/DEFAulT_RolEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/table/tableProcessing object type SCHEMA_EXPORT/table/table_DATA. . imported "HT1"."A" 11.00 KB 4 rows. . imported "HT1"."B" 11.00 KB 4 rowsJob "SYstem"."SYS_import_FulL_01" successfully completed at Tue Sep 10 06:40:16 2019 elapsed 0 00:00:01总结
以上是内存溢出为你收集整理的impdp 多个表空间到1个表空间通配符的使用全部内容,希望文章能够帮你解决impdp 多个表空间到1个表空间通配符的使用所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)