Re: Possibility of importing older dump to newer db server

It is absolutely possible to import an Oracle 9 dump into an Oracle 10 DB. Indeed, this is how many folks will perform an Oracle 9 => 10 "upgrade."

The basic suggestions from Oracle on exporting from one DB version and importing into another DB version are:

1. Export the data with the Export utility (exp) of the lowest database version involved.
2. Import the data with the Import utility (imp) of the target database.
3. Running an Oracle7 Export utility against an Oracle9i database is not supported.

If you want a ton of more info (assuming you have purchased support from Oracle) see MetaLink Note:132904.1 .

BTW - We are talking here about the old and venerable exp and imp utilities. All of this has nothing to do with the new DataPump utilities (expdp and impdp) that have been delivered with Oracle 10g.

HOW TO DO IT:

1. exp porkone/thepassword_at_myolddb [[some other params go here as appropriate]] file=/tmp/somefile.dmp

(for exports usually direct=y is one of the good params to use)

2) if you need to you should move the file to whatever machine you want to import on

3) make sure you have an account you want to import into has been created on the new DB ... unless, of course, you are doing full=y on both exp and imp command lines and are exporting & importing as system or some ther DBA.

4) imp porkone/thenewpassword_at_mynewdb [[some other params go here as appropriate]] file=/tmp/somefile.dmp

(for imports direct=y is never used)

Of course you can put the file above in any directory you want. It doesn't have to go in /tmp .

For a fuil list of options for either comand enter ...

exp help=y
-OR-
imp help=y

GOOD LUCK!!! Received on Tue Feb 28 2006 - 20:33:53 CST