ORACLE 11G EXP to import on Oracle 10G

Backup, Recover, Import, Export, Datapump, etc
Post Reply
fecomputacao
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Wed, 27 Jun 2012 3:48 pm

Good afternoon!

I have a database that is in Oracle 11G and need to generate a dump (using the EXP) to send to a client that owns Oracle 10G. How do I get this dump up on Oracle 10G without problem?

Is there any command that I should put on the EXP so that it knows that the version is from 10g?

Thanks!
User avatar
madmax
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 293
Joined: Wed, 13 Dec 2006 5:02 pm
Location: São Paulo
Contact:
________________________________
Douglas - Madmax.

Hello Fe.

Using the DataPump Must The Exp / Imp Simple You can with this example below passing as a parameter the bank version:

Select all

expdp test1/test1 file=11g1.dmp version='10.2.0.1' dumpfile=my10gv.dmp directory=dump_dir

Now if you want to use the EXP / IMP you must do the EXP of the 11G bank with a 10G client so I believe that you ~ and can import without error.

follows a link Explaining:
https://forums.oracle.com/forums/thread ... ID=2282879

I hope I have helped.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 5 guests