topic Re: Export/Import database between different version of oracles in Operating System - HP-UX

Export/Import database between different version of oracles

mahmoud_2 — Thu, 05 Aug 2004 08:53:19 GMT

I was exported a database from oracle 9i release 1 and i try to import it to oracle 10g
but it is not working, Why?

Re: Export/Import database between different version of oracles

Steve Steel — Thu, 05 Aug 2004 10:24:00 GMT

Hi

Probably oracle changed a table format

What error do you get

Steve Steel

Re: Export/Import database between different version of oracles

Hein van den Heuvel — Thu, 05 Aug 2004 10:58:11 GMT

We'd like to help, but we are not mindreaders.

It is supposed to work.
What is the EXACT error?

What did Oracle support tell you? Surely you went to Oracle first for an Oracle problem on a new version?

Regards,
Hein.

Re: Export/Import database between different version of oracles

Lee Tae-kyung — Thu, 05 Aug 2004 21:16:04 GMT

1. export the database of oracle 9i on the server of oracle 10g.
Example)
10gserver:dba> exp scott/tiger@oracle9iLink file = ora9.dmp full = y compress = n log = exp.log

2. import the export file on the server of oracle 10g.

Good luck~~

From Korean friend

Re: Export/Import database between different version of oracles

mahmoud_2 — Sun, 08 Aug 2004 00:54:05 GMT

i was enter the username/password
then when i put the path of .dmp file the import screen will be close?

but when i export from the same version will be work.