2

I have a 11.1 oracle server and I need to export a dump file for a client who has a 10.1 server.

While reading the documentation, I figured out I needed the 10.1 Export Utility. I searched the Oracle site and I couln't find it.

How can I get this utility? Thanks

1 Answer 1

5

To do this, you'll be wanting to use the 11.1 Data Pump (expdp/impdp) rather than exp/imp. With Data Pump you export using the higher version export utility with the VERSION= parameter.

For example:

expdp scott/tiger version=10.1 directory=DUMPDIR dumpfile=DUMPFILE.dmp logfile=DUMP.log

Don't forget to create the directory (using CREATE DIRECTORY DUMPDIR AS '/path/to/dir';) first.

4
  • And my client can import it with his imp.exe utility like a regular dump file?
    – Goldorak84
    Oct 3, 2012 at 13:24
  • 3
    No, import with impdp - 10.1 was the first version that came with this utility.
    – Philᵀᴹ
    Oct 3, 2012 at 13:25
  • If I have a client with 9.2? Am I in trouble?
    – Goldorak84
    Oct 3, 2012 at 13:29
  • 1
    9.2 is no longer supported.
    – Philᵀᴹ
    Oct 3, 2012 at 13:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.