Home » RDBMS Server » Server Utilities » How to Import Data
How to Import Data [message #636150] Sat, 18 April 2015 01:14 Go to next message
Messages: 2
Registered: April 2015
Location: pune
Junior Member
Respected sir,

i m using oracle 10g.i want to import data in oracle 10g which is to be exported in oracle 11g by using expdp.How its possible please guide me....
Thank u..........
Re: How to Import Data [message #636151 is a reply to message #636150] Sat, 18 April 2015 01:34 Go to previous messageGo to next message
John Watson
Messages: 8804
Registered: January 2010
Location: Global Village
Senior Member
With regard to your behaviour, you received three replies to your previous topic, none of which you acknowledged. You say "Respected sir", but that doesn't look like respect to me.

With regard to your question, your import data exported with expdp by using impdp. When going between releases, there are some compitibility issues that you may have to consider.
Re: How to Import Data [message #636153 is a reply to message #636150] Sat, 18 April 2015 03:47 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
For version compatibility, you need to use VERSION parameter.

For example,

expdp scott/tiger TABLES=scott.emp VERSION=10.2 DIRECTORY=data_pump_dir 
DUMPFILE=emp.dmp LOGFILE=emp.log

Now you can import the dump using IMPDP in your 10.2 version database.

Previous Topic: Expdp using query
Next Topic: import dump
Goto Forum:

Current Time: Mon Mar 27 05:58:25 CDT 2023