| How to Import Data [message #636150] |
Sat, 18 April 2015 01:14  |
 |
rahuljadhav90963@gmail.co
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  |
John Watson
Messages: 8966
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 |
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.
Regards,
Lalit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
