Skip to main content

Export / Import moving data between different Oracle versions


Different versions of the import utility are upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility.
Below grid is just a outline and there may be many considerations between YES and NO
Exp done with version:
7
8i
9i
10g
11g
Is compatible with Imp
7
YES
NO
NO
NO
NO
8i
YES
YES
NO
NO
NO
9i
YES
YES
YES
NO
NO
10g
YES
YES
YES
YES
NO
11g
YES
YES
YES
YES
YES

Comments

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID