Home » RDBMS Server » Server Utilities » Schema export with parallel parameter (Oracle 11g,12c, Unix)
Schema export with parallel parameter [message #677941] Fri, 25 October 2019 00:55 Go to next message
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
Re: Schema export with parallel parameter [message #677943 is a reply to message #677941] Fri, 25 October 2019 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What happened when you tried?

Re: Schema export with parallel parameter [message #677945 is a reply to message #677943] Fri, 25 October 2019 01:28 Go to previous messageGo to next message
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.
Re: Schema export with parallel parameter [message #677946 is a reply to message #677945] Fri, 25 October 2019 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Schema export with parallel parameter [message #677948 is a reply to message #677946] Fri, 25 October 2019 04:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What was the question?

Re: Schema export with parallel parameter [message #677960 is a reply to message #677945] Fri, 25 October 2019 08:03 Go to previous messageGo to next message
EdStevens
Messages: 1376
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 . . .
Re: Schema export with parallel parameter [message #677994 is a reply to message #677960] Tue, 29 October 2019 10:39 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Schema export with parallel parameter [message #678124 is a reply to message #677994] Tue, 12 November 2019 06:08 Go to previous messageGo to next message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Thank you
Re: Schema export with parallel parameter [message #678145 is a reply to message #678124] Wed, 13 November 2019 02:50 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
I assume you've spotted what you missed?
Previous Topic: ORA 39000 | ORA 39142
Next Topic: Datapump interview question
Goto Forum:
  


Current Time: Thu Mar 28 16:09:50 CDT 2024