OraFAQ Forum: Server Utilities » Schema export with parallel parameter

Home » RDBMS Server » Server Utilities » Schema export with parallel parameter (Oracle 11g,12c, Unix)

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

Schema export with parallel parameter [message #677941]

Fri, 25 October 2019 00:55

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi,

Can someone please confirm the export command for schema with parallel parameter.

expdp username/pwd directory=DATA_PUMP_DIR dumpfile=exp_SIMQ_QA.dmp SCHEMAS=SIMQ  logfile=exp_SIMQ_QA.log  parallel=4

Regards,
Balaji

Report message to a moderator

Re: Schema export with parallel parameter [message #677943 is a reply to message #677941]

Fri, 25 October 2019 01:26

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

Senior Member
Account Moderator

What happened when you tried?

Report message to a moderator

Re: Schema export with parallel parameter [message #677945 is a reply to message #677943]

Fri, 25 October 2019 01:28

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

It should work but when I told this answer in interview, the panel wasn't satisfied with me.

Report message to a moderator

Re: Schema export with parallel parameter [message #677946 is a reply to message #677945]

Fri, 25 October 2019 02:05

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

Senior Member
Account Moderator

If you just said "it should work" I understand they were not satisfied.
What did they say?

Report message to a moderator

Re: Schema export with parallel parameter [message #677948 is a reply to message #677946]

Fri, 25 October 2019 04:12

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

No, I did not say it should work to him. I told the export command which is mentioned above on top of this thread.
But he wasn't satisfied with the answer I gave.

[Updated on: Fri, 25 October 2019 04:12]

Report message to a moderator

Re: Schema export with parallel parameter [message #677949 is a reply to message #677948]

Fri, 25 October 2019 04:19

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

Senior Member
Account Moderator

What was the question?

Report message to a moderator

Re: Schema export with parallel parameter [message #677960 is a reply to message #677945]

Fri, 25 October 2019 08:03

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

BalajiDBA wrote on Fri, 25 October 2019 01:28

It should work but when I told this answer in interview, the panel wasn't satisfied with me.

You seem to have quite a history of posting interview questions . . .

Report message to a moderator

Re: Schema export with parallel parameter [message #677994 is a reply to message #677960]

Tue, 29 October 2019 10:39

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

He wasn't satisfied because your command won't work.
Read what the documentation has to say on the parallel parameter, you've missed something important.

Report message to a moderator