Database Utilities (MOSC)

MOSC Banner

Can original exp/imp 12.2 client be used to export from and import to an 11.2.0.4 DB?

I attempting to export several tables from an 11.2.0.4 database and then import those tables back into an 11.2.0.4 database. I do not have DBA access and I do not have an OS account on the database server. Additionally, I am not able to install any versions of the 11g client on my client. These are restrictions currently being placed on me by the client I am working with.

I can successfully export (exp) any and all of the tables I need, but when I attempt to import (imp) them, I get the error combination of IMP-00003, ORA-00942, IMP-00023. I had the DBA run the catexp.sh script just to make sure the views were installed and valid. I even ran my imp with the "display dmp contents only" option and I got the same errors.

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