Rookie first encounter this kind of problem, imp import the DMP file in Oracle error 2153, excuse me what reason be?

C: \ Users \ admin> Imp fd/zhao file=D: \ DMP \ home \ oracle \ DMP \ fd DMP full=y

Import: Release 11.2.0.4.0 - Production on Friday May 31 16:07:49 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.


To connect to: Oracle Database 11 g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options

Through regular path by EXPORT: V11.02.00 create the EXPORT file
Has been completed ZHS16GBK character sets and AL16UTF16 NCHAR import
in a character setBeing imported into the FD objects FD
IMP - 00017:2153 due to ORACLE error, the following statement failure:
The CREATE DATABASE LINK DBL_SW_KY "CONNECT TO" KY_TYINTF "IDENTIFIED BY VALUE"
"' S 06490 b0905ea8ab03fdf278c0d4c3b94c69fb81a5824dea74b631fddf1ae20b88e04eb90"
"DCBFCF352680AC07292A0E3385BBB494ABF01731A5FBBEB7AE3C3287F4BC18DF604C7D1A38C
""15 cd3dde049ae31fa6b4d645ac8222715e78706efb4df1a95a18deb8ada50c086c9e044a00f
""AACA831B3F1D96B46A3BDA322C6264D430 'USING' (the DESCRIPTION="
"(ADDRESS_LIST="
"(ADDRESS=(TCP) PROTOCOL=(HOST=10.1.4.209) (1521) PORT=)"

")""(CONNECT_DATA=" https://bbs.csdn.net/topics/
"(=DEDICATED SERVER)"
"(SERVICE_NAME=former)"

")""
") 'IMP - 00003: ORACLE error 2153
ORA - 02153: invalid password string VALUES
.. is import table "AA" imported 1968 lines
.. is import table "AAAAA" imported 141 lines
.. is import table "AA_4102" imported 258 lines
.. is import table "ABST" import a 3 lines
.. is import table "ABST1" imported the row 0
.. is import table "ACCOUNTBOOK_DEF" import a 19 lines
.. is import table "ACNT_DEF" imported 301 rows

CodePudding user response:

Failed to create dblink, it doesn't matter

CodePudding user response:

Well, didn't create dblink, data import, to create it,