| Export/Import Criteria [message #663166] |
Wed, 24 May 2017 09:25  |
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
|
Junior Member |
|
|
I need someone to confirm, must I create export dump file before starting the import on the target database?
I googled and Check my documents but no direct answer to this question
If no, kindly give me sample script that can import without export dump file.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Export/Import Criteria [message #663180 is a reply to message #663179] |
Wed, 24 May 2017 12:15  |
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
|
Junior Member |
|
|
|
Dear Micheal, my question is I have a schema in oracle 11g, I want to import it to oracle 12c, using expdp and impdp. Must I need to create .dmp file using expdp command before impdp, that is my question, I just want clarification, I am preparing for my oracle 12c upgrade exam.
|
|
|
|
| Re: Export/Import Criteria [message #663181 is a reply to message #663180] |
Wed, 24 May 2017 12:19 |
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
|
Junior Member |
|
|
Is it a must to do something like this:
expdp user_name FULL=y DUMPFILE=expdat.dmp DIRECTORY=data_pump_dir
TRANSPORTABLE=always VERSION=12.0 LOGFILE=export.log
before:
impdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 LOGFILE=schemas.log
DUMPFILE=expdat.dmp ABORT_STEP=-1
|
|
|
|
| Re: Export/Import Criteria [message #663182 is a reply to message #663180] |
Wed, 24 May 2017 12:19 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
dapoeb wrote on Wed, 24 May 2017 19:15Dear Micheal, my question is I have a schema in oracle 11g, I want to import it to oracle 12c, using expdp and impdp. Must I need to create .dmp file using expdp command before impdp, that is my question, I just want clarification, I am preparing for my oracle 12c upgrade exam.
And the link answers this question.
Did you at least read the "Purpose" paragraph?
[Updated on: Wed, 24 May 2017 12:22] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Export/Import Criteria [message #663188 is a reply to message #663186] |
Wed, 24 May 2017 12:54 |
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
|
Junior Member |
|
|
Micheal, Thanks for your patient, have seen what you refers to.
When you are Importing via Database Link, there is no need for dump file.
|
|
|
|
| Re: Export/Import Criteria [message #663189 is a reply to message #663186] |
Wed, 24 May 2017 12:58 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
It would be interesting to know the real question here.
It might be stripped down to simply can you import a file before you have created the export file? In this case, the question seems silly.
If it is a little more advanced of can you do a datapump import without having to create an export FILE, then the link provided will give the answer, with examples.
I am not too sure the OP is asking the right question.
|
|
|
|
| Re: Export/Import Criteria [message #663190 is a reply to message #663189] |
Wed, 24 May 2017 13:13 |
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
|
Junior Member |
|
|
Dear joy_division, in the cloud of intellectual gathering and knowledge, ambiguous word is not really appreciable, you can can make your comment without using abuse word.
Also realize that we are not all at the same level of understanding in oracle. A word is enough for the wise.
|
|
|
|
| Re: Export/Import Criteria [message #663191 is a reply to message #663190] |
Wed, 24 May 2017 14:05 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Well, I share the same dilemma as Joy Division.
Your first question was: "must I create export dump file before starting the import on the target database?", explicitly stating that import over database link is out of question and that you have to use "expdp and impdp functionality" (your second message).
At the first sight, I thought that it is more than obvious: if you have to use IMPDP, where would you take data from, unless you use EXPDP first? Don't you agree?
One of your subsequent messages says: "My question is I have a schema in oracle 11g, I want to import it to oracle 12c, using expdp and impdp. Must I need to create .dmp file using expdp command before impdp, that is my question, I just want clarification, I am preparing for my oracle 12c upgrade exam."
I'm afraid that this is (sadly) yet another example of an Oracle user who might be able to talk the talk, but is unable to walk the walk.
Finally, I strongly disagree with you, saying that Joy Division used "abuse word". Where? Which one?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
