今天使用oracle 19c进行pdb导数的时候,发现如下报错ORA-01017:
- impdp mei1/"密码"@mei19c directory=MEI1_EXPDP dumpfile=mei1_20230913_01.dmp logfile=mei1_impdp_20230913.log schemas=MEI1 REMAP_TABLESPACE=DATA_SERA:orcl
- Import: Release 19.0.0.0.0 - Production on Wed Sep 13 11:28:12 2023
- Version 19.3.0.0.0
-
- Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
-
- UDI-01017: operation generated ORACLE error 1017
- ORA-01017: 用户名/口令无效; 登录被拒绝
-
- Username: UDI-00005: unexpected End-Of-File encountered while reading input.
尝试用sqlplus 登录又正常,很是奇怪
sqlplus mei1/"密码"@mei19c
将@前面的 用户名/密码,用单引号括起来。问题解决
impdp 'mei1/"密码"'@MEI19C directory=MEI1_EXPDP dumpfile=mei1_20230913_01.dmp logfile=mei1_impdp_20230913.log schemas=MEI1 REMAP_TABLESPACE=DATA_SERA:orcl