Database – How to restore/import an Oracle database from dmp file

The free and open-source SchemaCrawler tool that I wrote will do what you need. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. You can use a standard diff program to diff the current output with a reference version of the output.

https://www.SchemaCrawler.com

You will need to provide a JDBC driver for your database.

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:

• http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/exp_imp.htm