Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 5 down vote accepted

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.

share|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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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