Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was wondering, where can i find a step-by-step guide on how to export from a higher version (11g) to a lower version (9i and 10g) of oracle database? Thank you very much!

share|improve this question

I believe export from 11g to 9i is not supported but will probably work. 11g to 10g is fine. Basic rules are:

  • Export data using the export utility supplied with the lowest of the two databases.
  • Import data using the import utility supplied with the target database.

Ideally you want to be using the latest patch release of each version.

You can find the full documentation including step-by-step operation of the export and import utilities here:

share|improve this answer

Your Answer


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