Oracle IMP-00013 When importing DMP files: Only DBAs can import files exported by other DBAs

Requires authorization to import the user as a DBA.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7D/63/wKiom1bnezjTXhfsAAF7PNNPvuo449.jpg "title=" Error.jpg "alt=" Wkiom1bnezjtxhfsaaf7pnnpvuo449.jpg "/>

Then use this user name for import, note that import users and DMP export users need to be consistent.

If Connect/as sysdba, the prompt ora-01031:insufficient privileges appears,

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/7D/60/wKioL1bnfFrTIoNIAABA7Fi5yQE778.jpg "title=" Error2.jpg "alt=" Wkiol1bnffrtioniaaba7fi5yqe778.jpg "/>

First step: see if the system user belongs to ORA_DBA, if not in the ORA_DBA group, Add.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7D/63/wKiom1bnfbmQ1VinAADMQF5ASlY773.jpg "title=" Error3.jpg "alt=" Wkiom1bnfbmq1vinaadmqf5asly773.jpg "/>

Second cloth: Check whether the sqlnet.authentication_services setting in Sqlnet.ora is NTS, if not, modify the result sqlnet.authentication_services= (NTS).

Step Three: Check the environment variable if path Server/bin is in front of Client_1\bin, and the query Client_1\bin is preceded by Server/bin as follows:

d:\oracle\product\10.2.0\client_1\bin;d:\oracle\product\10.2.0\db_1\bin;%systemroot%\system32;%systemroot%;% Systemroot%\system32\wbem;%systemroot%\system32\windowspowershell\v1.0\;%java_home%\bin

After modification

d:\oracle\product\10.2.0\db_1\bin;d:\oracle\product\10.2.0\client_1\bin;%systemroot%\system32;%systemroot%;% Systemroot%\system32\wbem;%systemroot%\system32\windowspowershell\v1.0\;%java_home%\bin

Fourth step: Reopen the Command Window (required), and then log back in.

Oracle IMP-00013 When importing DMP files: Only DBAs can import files exported by other DBAs