OraFAQ Forum: Server Utilities » Export/Import Criteria

Home » RDBMS Server » Server Utilities » Export/Import Criteria (11g and 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Export/Import Criteria [message #663169 is a reply to message #663166]

Wed, 24 May 2017 09:41

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Do you mean Importing over a database link?

Report message to a moderator

Re: Export/Import Criteria [message #663175 is a reply to message #663169]

Wed, 24 May 2017 12:06

dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria

Junior Member

No, expdp and impdp functionality

Report message to a moderator

Re: Export/Import Criteria [message #663176 is a reply to message #663175]

Wed, 24 May 2017 12:06

dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria

Junior Member

The general syntax

Report message to a moderator

Re: Export/Import Criteria [message #663178 is a reply to message #663175]

Wed, 24 May 2017 12:07

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

dapoeb wrote on Wed, 24 May 2017 19:06

No, expdp and impdp functionality

Isn't the link about impdp?

Report message to a moderator

Re: Export/Import Criteria [message #663179 is a reply to message #663176]

Wed, 24 May 2017 12:08

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

dapoeb wrote on Wed, 24 May 2017 19:06

The general syntax

Does the link not contain an example?

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Re: Export/Import Criteria [message #663182 is a reply to message #663180]

Wed, 24 May 2017 12:19

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: Export/Import Criteria [message #663185 is a reply to message #663183]

Wed, 24 May 2017 12:34

dapoeb
Messages: 24
Registered: April 2010
Location: Lagos-Nigeria

Junior Member

Example Where??

Report message to a moderator

Re: Export/Import Criteria [message #663186 is a reply to message #663185]

Wed, 24 May 2017 12:39

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Re: Export/Import Criteria [message #663191 is a reply to message #663190]

Wed, 24 May 2017 14:05

Littlefoot
Messages: 21824
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?

Report message to a moderator

Re: Export/Import Criteria [message #663464 is a reply to message #663191]

Mon, 05 June 2017 03:36

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

"silly", I suspect Wink

Wink

Report message to a moderator

Previous Topic:	SQLLDR Issue with NUMBER data type
Next Topic:	Issue in SQL loader control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 05 02:53:09 CDT 2025