OraFAQ Forum: Server Utilities » Multiple Export Dump File generation using %u.

Home » RDBMS Server » Server Utilities » Multiple Export Dump File generation using %u. (Oracle 12c, windows 2012)

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

Multiple Export Dump File generation using %u. [message #644793]

Wed, 18 November 2015 00:02

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

I had a problem of Slowness in EXPDP, so we have decided to use parallel option and the symbol of .%u to split the export dump file into many files.

Now the speed is good. But the problem is when we just want to import a particular object, then how we can come to know which dump file among many have that particular object.

How we can find it out.

Regards
Muktha

Report message to a moderator

Re: Multiple Export Dump File generation using %u. [message #644795 is a reply to message #644793]

Wed, 18 November 2015 00:36

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

Senior Member
Account Moderator

You you can't know this, you have to give/name all the files to Oracle and import itself will know in which files are the segments you want.

Report message to a moderator

Re: Multiple Export Dump File generation using %u. [message #644797 is a reply to message #644795]

Wed, 18 November 2015 00:45

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Thanks for the reply, kindly guide me how we can include more than one dump file name?

Regards
Muktha

Report message to a moderator

Re: Multiple Export Dump File generation using %u. [message #644798 is a reply to message #644797]

Wed, 18 November 2015 00:51

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

Senior Member
Account Moderator

Kindly read the documentation.

Report message to a moderator

Re: Multiple Export Dump File generation using %u. [message #644800 is a reply to message #644798]

Wed, 18 November 2015 01:20

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

Sorry for irritated you,

Because it was giving error I had to ask you.

NOw i have found the way:

impdp system/***** dumpfile=EXPORT_10-10-2015.%u.dmp logfile=name.log

Regards
Muktha

Report message to a moderator

Re: Multiple Export Dump File generation using %u. [message #644802 is a reply to message #644800]

Wed, 18 November 2015 02:04

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

Senior Member
Account Moderator

Quote:

Because it was giving error I had to ask you.

And you think it is useless to post what you do and get to help us to help you?

Anyway, thanks for your feedback.

Report message to a moderator

Re: Multiple Export Dump File generation using %u. [message #644803 is a reply to message #644802]

Wed, 18 November 2015 02:24

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

I didn't mean that,

I was trying like dumpfile=dump01.dmp,dump02.dmp,dump03.dmp

Thanks and Regards
Muktha

Report message to a moderator

Previous Topic:	Initiate Expdp/impdp from oracle procedure.
Next Topic:	how to import data over network

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 17:20:15 CST 2025