I have two databases on two machines: one 9i and one is 11g.
I have one schema i need to export from 9i to 11g.
Assume you do not have dba role, what minimum privs you need to do that?
I think I would need to issue "drop user myapp" before doing the impor to clean up everything and then creating the user and then the import. I think this is the normal Standard procedure for doing it.