IMP.EXE not working in 11gR2 as it did in previous versions
263048Mar 29 2011 — edited Mar 14 2013I am trying to restore a database which was backed up using EXP.EXE on Oracle 10g to a new Oracle 11gR2 instance.
I was having trouble with the tablespaces at first and finally gave the user unlimited quota on the data and index tablespaces. The scripted commands used to create the user used to accomplish this, but apparently this doesn't work in 11gR2 and I had to do it one at a time through the database management web page.
Once I got past this, I still had trouble because of a reporting user granted access to the original database did not exist in my new instance. This was never a problem in earlier versions and it used to restore the database and just allow those grants to fail. I created the reporting user in my new instance and now IMP.EXE just fails after restoring the sequences and one table (of many) with no errors output to the console.
What needs to be done to get IMP.EXE to behave like it did in previous versions? Why is it failing after restoring the first table?
If it makes a difference, the OS is Win7 x64.
Rod