Exp and Imp on 9i and 11g DBs
I need to move all, but data, on a scema from 9i DB (9.2.0.8) to 11g DB (11.1.0.7).
On the source DB,
exp system/PWD@SID file=c:\temp\exp.dmp log=c:\temp\exp.log owner=staging row=no
It was working on the exp. Then the file, c:\temp\exp.dmp, was copied to the target DB.
I had problems to run below on the target DB because of no 'OWNER' on imp.exe
imp system/PWD@SID file=c:\temp\exp.dmp log=c:\temp\exp.log owner=staging row=no
Please advise me how I can do it?