Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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