Database Utilities (MOSC)

MOSC Banner

Exp and Imp on 9i and 11g DBs

edited Jun 3, 2010 7:43AM in Database Utilities (MOSC) 2 commentsAnswered
 Hi Oracle,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center