How to solve the 1017 error of imp in oracle

Solution: 1. Use the "grant resource/connect to username" statement to add "resource / connect" permissions to the user; 2. Enter the user in the format of "test_opr as sysdba" in the prompt below the error Name, press Enter and then enter the user's login password.

The operating environment of this tutorial: Windows 10 system, Oracle version 12c, Dell G3 computer.

How does oracle solve the 1017 error of imp

The example is as follows:

For this problem

1. Give the user resource/connect permissions

grant resource/connect to 用户名

Solution:

2. Enter the user name in the prompt below

@SYSDNBA

Enter the password again

Or when importing through the command

imp test_opr/test@orcl file=e:\test_opr.dmp fromuser=test_opr touser=test_opr

prompts to enter the user name, please note that the input format is

test_opr as sysdba

Press Enter and enter the login password of test_opr to start importing.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to solve the 1017 error of imp in oracle. For more information, please follow other related articles on the PHP Chinese website!