imp 9i data into my 8 db

[engiri]

I want to import my 9i export dmp into my 8 db.
somewhere i saw connect through 8's exp utility
and connect to 9idb.
the connection itself gives errors tnserror.
Any helps?

[davey23uk]

does you tnsnames.ora for your 8i home have an entry for the 9i database?

[slimdave]

Originally posted by engiri
the connection itself gives errors tnserror.
Any helps?

What errors?

[thanigai]

I know lower version (export dump)to higher version(import) is possible...
can this 9i export dump to import into (8) is possible?.
becasue when we tried 8.1.7.4 to 8.1.6 we were told not possible.
what is the error you are getting?.

Thanks,
Thanigaivasan.

[davey23uk]

you can see in his post he says he is trying to connect 8i exp to 9i db which is perfectly possible

[engiri]

Originally posted by thanigai

can this 9i export dump to import into (8) is possible?.
Thanks,
Thanigaivasan.

Ya. i also want to import into another db Oracle 8 from 9i.
12154

[aspdba]

I think you can do that by using 8i exp to get 9i dump and then import it to your 8i db.

[engiri]

Originally posted by aspdba
I think you can do that by using 8i exp to get 9i dump and then import it to your 8i db.

Then from 8i to 8..
is there any way for 9i-->8 directly?

[davey23uk]

have you tried using the 8 exp against 9i db, might work - dunno