Home > database >  Rookie database IMP import problem.. 50 points
Rookie database IMP import problem.. 50 points

Time:09-26

I deduced from a database using PLSQL transout201509. The DMP file, now want to import to another garage, I use the CMD window to perform on the local computer times wrong,

C: \ Users \ Administrator> Imp hisuser/hisuser @ former file=H: \ bf \ TRANSOUT \ transout2015
09. DMP full=y ignore=y;

Import: Release 11.2.0.1.0 - Production on Monday November 20 13:55:48 2017

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


IMP - 00058: ORACLE error 1017
ORA - 01017: invalid username/password. Logon denied username:

Excuse me what's the problem cause and how to solve?

CodePudding user response:

Username/password does not match, this misstatement for more clearly

CodePudding user response:

In addition, given that you are using PLSQL exported, don't know what to guide a version, and export the also don't know use what version of the client, so, even if you solved the problem of the username/password, I'm afraid down or treat,

CodePudding user response:

I use hisuser choose the former can login PLSQL, why can't login under IMP?

CodePudding user response:

What is the IMP login?

CodePudding user response:

C: \ Users \ Administrator> Imp

Import: Release 11.2.0.1.0 - Production on Monday November 20 14:39:55 2017

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

User name: hisuser
Password:

IMP - 00058: ORACLE error 1017
ORA - 01017: invalid username/password. Logon denied username:

-- this is IMP login,,

CodePudding user response:

The
reference 3 floor BLACK09222 response:
I use hisuser choose the former can login PLSQL, why cannot login under IMP?


And see if it is case sensitive

CodePudding user response:

Database name without input password login?

Password to lose: password @ the database name,
Such as: user password @ former

CodePudding user response:

Up sqlplus/nolog

Conn hisuser/hisuser @ former
Look at that can not connect

CodePudding user response:

Reading newspapers in PLSQL import directly is not wrong
  • Related