0

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?

Martin Prikryl
  • 188,800
  • 56
  • 490
  • 992
Mat
  • 140
  • 2
  • 11
  • Then the user you are logging in as is missing some privileges. – OldProgrammer Mar 20 '15 at 12:58
  • I got that, but I can't tell which privileges - as I said, I have been able to import other dmp files. Is there any way to limit IMP to only look at creating tables and data? – Mat Mar 20 '15 at 13:00
  • You were successful before connecting as the same user? Is this a full dump (which needs `imp_full_database`) while previous ones were schema/table dumps, perhaps? – Alex Poole Mar 20 '15 at 13:09
  • That could be the case, I didn't generate the dmp files. I can see if I can get that permission and try again. Do you know how I would find out if it is a full dump? – Mat Mar 20 '15 at 13:19
  • Sorry, I missed that was was prompting for username; so that user can't even connect properly. Can you connect to that user/pass@tns with SQL\*Plus? Are you trying to connect as a privileged user maybe? – Alex Poole Mar 20 '15 at 14:26
  • I can connect with my username and password with SQL*Plus and if I add the argument `SHOW=Y` it ends with `import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) . importing SINV's objects into Import terminated successfully without warnings.` – Mat Mar 20 '15 at 15:03
  • If you aren't connecting as SINV (i.e. `` is something else) then you're doing at least a fromuser/touser import, I think, so that privilege is still needed. Seeing the full command you're using, and one that's previously worked, might help. I'm rusty on legacy `imp`, life is easier with `impdp` *8-) – Alex Poole Mar 20 '15 at 17:03
  • If only I'd received the data with impdp, sadly not an option :( I've asked for imp_full_database, so I will try it with that. – Mat Mar 21 '15 at 17:51

1 Answers1

0

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!

Mat
  • 140
  • 2
  • 11