Import: Release 19.0.0.0.0 - Production on 星期三 5月 25 15:08:38 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: 参数值无效
ORA-39000: 转储文件说明错误
ORA-39155: 展开转储文件名 "D:\programs\oracle19c\dbhome\oradata\dir\ATMB_CWGL_01_2022031512001647316801.dmp" 时出错
ORA-48128: 不允许打开符号链接
C:\WINDOWS\system32>
https://blog.csdn.net/murkey/article/details/106242319
是19C的一个bug，也可能和expdp导出时候没有设置cluster=n有关
CAUSE
Error can happen at symbolic link internal check stage.
Unpublished BUG 27598040 has been created and at time of creating this document, development is working on this issue.
SOLUTION：
The following workaround has been verified by development for this issue:
ALTER SYSTEM SET “_disable_directory_link_check” =true SCOPE=SPFILE;
Restart the database.
评论
有用 0
impdp user/user directory=DATA_TMP_DIR dumpfile=ATL_%U_2022031512001647316801.dmp remap_schema=ATL:ATL_YS remap_tablespace=ATL:ATL_YS logfile=ATL_YS_imp001.log
评论 有用 0是使用expdp导出四个dump文件，使用%U参数，生成四个dump文件
ATL_01_2022031512001647316801.dmp
ATL_02_2022031512001647316801.dmp
ATL_03_2022031512001647316801.dmp
ATL_04_2022031512001647316801.dmp
评论 有用 0dumpfile允许写成ATL_01_2022031512001647316801.dmp，ATL_02_2022031512001647316801.dmp，ATL_03_2022031512001647316801.dmp，ATL_04_2022031512001647316801.dmp嘛
评论 有用 0你看你的报错是
ORA-39155: 展开转储文件名 “D:\programs\oracle19c\dbhome\oradata\dir\ATMB_CWGL_01_2022031512001647316801.dmp” 时出错
但是你的导入是
ATL_01_2022031512001647316801
ATL_02_2022031512001647316801
······
directory=DATA_TMP_DIR dumpfile=ATL_%U_2022031512001647316801.dmp
你这两个参数确认一下：1.dump文件放到了这个directory对应的目录下；2.你这个dumpfile看着没啥问题，在执行看看，如果还是有问题把%转义一下，%啥的都试试
评论 有用 0
墨值悬赏