Home » RDBMS Server » Server Utilities » Export/Import Criteria (11g and 12c)
Export/Import Criteria [message #663166] Wed, 24 May 2017 09:25 Go to next message
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 #663169 is a reply to message #663166] Wed, 24 May 2017 09:41 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
Do you mean Importing over a database link?
Re: Export/Import Criteria [message #663175 is a reply to message #663169] Wed, 24 May 2017 12:06 Go to previous messageGo to next message
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
Junior Member
No, expdp and impdp functionality
Re: Export/Import Criteria [message #663176 is a reply to message #663175] Wed, 24 May 2017 12:06 Go to previous messageGo to next message
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
Junior Member
The general syntax
Re: Export/Import Criteria [message #663178 is a reply to message #663175] Wed, 24 May 2017 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dapoeb wrote on Wed, 24 May 2017 19:06
No, expdp and impdp functionality
Isn't the link about impdp?

Re: Export/Import Criteria [message #663179 is a reply to message #663176] Wed, 24 May 2017 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dapoeb wrote on Wed, 24 May 2017 19:06
The general syntax
Does the link not contain an example?


Re: Export/Import Criteria [message #663180 is a reply to message #663179] Wed, 24 May 2017 12:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

dapoeb wrote on Wed, 24 May 2017 19:15
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.
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 #663183 is a reply to message #663181] Wed, 24 May 2017 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dapoeb wrote on Wed, 24 May 2017 19:19
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
Did you read the "Example" paragraph?

Re: Export/Import Criteria [message #663185 is a reply to message #663183] Wed, 24 May 2017 12:34 Go to previous messageGo to next message
dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria
Junior Member
Example Where??
Re: Export/Import Criteria [message #663186 is a reply to message #663185] Wed, 24 May 2017 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In the link: Ctl-F -> Example
Read the whole 3.4.24 section and you will find the example at the end.

[Updated on: Wed, 24 May 2017 12:40]

Report message to a moderator

Re: Export/Import Criteria [message #663188 is a reply to message #663186] Wed, 24 May 2017 12:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
joy_division
Messages: 4794
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21240
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?
Re: Export/Import Criteria [message #663464 is a reply to message #663191] Mon, 05 June 2017 03:36 Go to previous message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
"silly", I suspect Wink
Previous Topic: IMP-00017: following statement failed with ORACLE error 922
Next Topic: Issue in SQL loader control file
Goto Forum:
  


Current Time: Wed Nov 22 20:00:13 CST 2017

Total time taken to generate the page: 0.01656 seconds