Home » RDBMS Server » Server Utilities » export from 11g and import to 10g (oracle 11.2 nd 10.2 ,windows 7)
export from 11g and import to 10g [message #636848] Mon, 04 May 2015 06:54 Go to next message
hcdba
Messages: 34
Registered: March 2015
Member
hello

I have one confusion here. today i practice for import export whole database using exp imp command in oracle.

- i have oracle 11g database in my vmware and in my desktop i have oracle 10g database.
- now i am using exp command create dump file and imp in to oracle 10g database
- but it giving error some like header not matched of dump file.
- i dont know but i may be its version compatibility error.

can you guide me how to resolve this error.
it is possible to import export from higher version to lower version in oracle

thanx in advance.
Re: export from 11g and import to 10g [message #636853 is a reply to message #636848] Mon, 04 May 2015 07:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
VERSION=10.2.0.4

It appears GOOGLE is broken for you. Sad

http://dba.stackexchange.com/questions/25354/how-do-i-export-data-from-oracle-11-1-to-10-1
Re: export from 11g and import to 10g [message #636859 is a reply to message #636848] Mon, 04 May 2015 07:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
- i dont know but i may be its version compatibility error.


This is sure.

Quote:
can you guide me how to resolve this error.


Use Data Pump with VERSION parameter to generate a compatible dump.

Re: export from 11g and import to 10g [message #636880 is a reply to message #636859] Tue, 05 May 2015 01:20 Go to previous message
hcdba
Messages: 34
Registered: March 2015
Member
done thanx a lot
Previous Topic: load data from another table/flat file
Next Topic: How to export all of my procedure and packeges from my schema?
Goto Forum:
  


Current Time: Thu Mar 28 15:56:00 CDT 2024