Home » RDBMS Server » Server Utilities » Multiple Export Dump File generation using %u. (Oracle 12c, windows 2012)
Multiple Export Dump File generation using %u. [message #644793] Wed, 18 November 2015 00:02 Go to next message
muktha_22
Messages: 526
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
Re: Multiple Export Dump File generation using %u. [message #644795 is a reply to message #644793] Wed, 18 November 2015 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Multiple Export Dump File generation using %u. [message #644797 is a reply to message #644795] Wed, 18 November 2015 00:45 Go to previous messageGo to next message
muktha_22
Messages: 526
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
Re: Multiple Export Dump File generation using %u. [message #644798 is a reply to message #644797] Wed, 18 November 2015 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Kindly read the documentation.

Re: Multiple Export Dump File generation using %u. [message #644800 is a reply to message #644798] Wed, 18 November 2015 01:20 Go to previous messageGo to next message
muktha_22
Messages: 526
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
Re: Multiple Export Dump File generation using %u. [message #644802 is a reply to message #644800] Wed, 18 November 2015 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Multiple Export Dump File generation using %u. [message #644803 is a reply to message #644802] Wed, 18 November 2015 02:24 Go to previous message
muktha_22
Messages: 526
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
Previous Topic: Initiate Expdp/impdp from oracle procedure.
Next Topic: how to import data over network
Goto Forum:
  


Current Time: Tue Jul 14 07:54:43 CDT 2020