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

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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