topic Re: data Transfer from 10g to 9i in Operating System - HP-UX

data Transfer from 10g to 9i

Asif_8 — Sat, 16 Jun 2007 06:18:49 GMT

Hi !

Can i data transfer from 10g to 9i if how

Export the data by exp from 10g and import buy imp in 9i

Re: data Transfer from 10g to 9i

Srimalik — Sat, 16 Jun 2007 11:04:23 GMT

Exp and emp should(will) work.

If the 10g dump file format has changed and imp of 9i do not know the format than there will be a problem.

Re: data Transfer from 10g to 9i

Hein van den Heuvel — Sat, 16 Jun 2007 11:25:48 GMT

Why ask in an HPUX focussed forum?
This is 100% an Oracle question.
Ask Oracle! Or ask in an Oracle focussed forum.

fwiw,
Hein.

Re: data Transfer from 10g to 9i

Srimalik — Sat, 16 Jun 2007 12:08:27 GMT

Hein,

I think this is a forum for all the database(installed on HPUX) related queries.

And such posts are allowed to be posted on this forum. else I do not see any use of this forum.

Re: data Transfer from 10g to 9i

Noble Sebastian — Sat, 16 Jun 2007 15:43:48 GMT

Hi ,
We can do , but befre we run some script .

regards
Noble

Re: data Transfer from 10g to 9i

Asif_8 — Sat, 16 Jun 2007 23:35:29 GMT

Hi Nobel !

If yoy step by step what script you run?
and why you run this script what script do

asif

Re: data Transfer from 10g to 9i

Ariel Cary — Sun, 17 Jun 2007 14:53:27 GMT

Hi,

This is the general migration rule for exp/imp tasks. Use the lower exp version of the two databases. Then, imp back using the target database version. This will guarantee you won't get into compatibility issues.

e.g.
1. You want to go from 9i to 10g. Export (the 9i db) using 9i exp. Then, imp (into the 10g db) using 10g imp.

2. You want to go from 10g to 9i. Export (your 10g db) using 9i exp. Then, imp (into the 9i db) using the 9i imp.

HTH,

-Ariel

Re: data Transfer from 10g to 9i

Yogeeraj_1 — Sun, 17 Jun 2007 23:58:19 GMT

hi Asif,

as Ariel mentions in the previous post, you need to use the 9i executables to EXP the data and then again the 9i IMP to import the data in the target database.

e.g.
1. On the server that is running the 10g database, install the software for 9i (do not create the database)
NB. alternatively, if you have a fast network link, you can as well issue the EXP from the 9i host itself.

2. EXP the 10g database using the 9i EXP program

3. Transfer the DUMP files (or alternatively make it available on the 9i host through NFS)

4. On the 9i host, use IMP to import the database.

if you need more detailed information about the IMP and EXP commands, please do let us know.

kind regards
yogeeraj