oracleimportoracle11gimp

Using Oracle IMP gives the error IMP-00058

I have received some data in Oracle DMP format that I am trying to use imp to import into an Oracle database.

I am running the command: imp <user>/<pass>@<tns> FILE=SI_DESIGN_SETS_12Mar2015.dmp

I get the result: 

 Import: Release 11.2.0.1.0 - Production on Fri Mar 20 11:59:37 2015

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


 IMP-00058: ORACLE error 1031 encountered
 ORA-01031: insufficient privilegesUsername:

Running this command with other dmp files has worked in the past. Any ideas on how to get past this error?

Solution

  • In case anyone is wondering, I managed to get them to regenerate them and bizarrely adding "FEEDBACK=1000" to the import command actually made some of the old ones work!