OraFAQ Forum: Server Utilities » Datapump interview question

Home » RDBMS Server » Server Utilities » Datapump interview question (Oracle 11g,12c, Unix)

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

Datapump interview question [message #677078]

Fri, 16 August 2019 03:10

BalajiDBA
Messages: 60
Registered: October 2018

Member

Hi,

How to export/import without using external directory?

Can you please answer this datapump question?

Regards,
Balaji

Report message to a moderator

Re: Datapump interview question [message #677084 is a reply to message #677078]

Fri, 16 August 2019 09:44

EdStevens
Messages: 1189
Registered: September 2013

Senior Member

BalajiDBA wrote on Fri, 16 August 2019 03:10

Hi,

How to export/import without using external directory?

Can you please answer this datapump question?

Regards,
Balaji

What, exactly, do you mean by "external directory"?

What does the documentation say about directory specification?
https://docs.oracle.com/database/121/SUTIL/GUID-5F7380CE-A619-4042-8D13-1F7DDE429991.htm#SUTIL200

Report message to a moderator

Re: Datapump interview question [message #677086 is a reply to message #677078]

Fri, 16 August 2019 10:10

BlackSwan
Messages: 26669
Registered: January 2009
Location: SoCal

Senior Member

BalajiDBA wrote on Fri, 16 August 2019 01:10

Hi,

How to export/import without using external directory?

Can you please answer this datapump question?

Regards,
Balaji

use obsoleted utilities exp & imp instead of expdp & impdp

Report message to a moderator

Re: Datapump interview question [message #677087 is a reply to message #677078]

Fri, 16 August 2019 14:52

John Watson
Messages: 8207
Registered: January 2010
Location: Global Village

Senior Member

From where are you getting these questions? And what is the motivation for asking?

Report message to a moderator

Re: Datapump interview question [message #677132 is a reply to message #677087]

Wed, 21 August 2019 00:09

BalajiDBA
Messages: 60
Registered: October 2018

Member

This question was asked in interview.

Report message to a moderator

Re: Datapump interview question [message #677135 is a reply to message #677132]

Wed, 21 August 2019 06:35

EdStevens
Messages: 1189
Registered: September 2013

Senior Member

BalajiDBA wrote on Wed, 21 August 2019 00:09

This question was asked in interview.

And what answer did you give? And what discussion resulted?

And what did you find when you consulted the documentation, as I suggested on Friday - five days ago?

[Updated on: Wed, 21 August 2019 06:36]

Report message to a moderator

Re: Datapump interview question [message #678126 is a reply to message #677135]

Tue, 12 November 2019 06:14

BalajiDBA
Messages: 60
Registered: October 2018

Member

use obsoleted utilities exp & imp instead of expdp & impdpQuote:

Thanks Blackswan

Report message to a moderator

Re: Datapump interview question [message #678127 is a reply to message #678126]

Tue, 12 November 2019 06:16

BalajiDBA
Messages: 60
Registered: October 2018

Member

And what answer did you give? And what discussion resulted?Quote:

I said I don't know the answer for this question.

Quote:

And what did you find when you consulted the documentation, as I suggested on Friday - five days ago?

I didn't find any related to my question in document.

Report message to a moderator

Re: Datapump interview question [message #678128 is a reply to message #678127]

Tue, 12 November 2019 07:27

EdStevens
Messages: 1189
Registered: September 2013

Senior Member

BalajiDBA wrote on Tue, 12 November 2019 06:16

And what answer did you give? And what discussion resulted?Quote:
I said I don't know the answer for this question.

Quote:
And what did you find when you consulted the documentation, as I suggested on Friday - five days ago?
I didn't find any related to my question in document.

Sometimes you have to infer the answer.
From the 12c Utilities manual:

DIRECTORY

Default: DATA_PUMP_DIR

Purpose

Specifies the default location to which Export can write the dump file set and the log file.

Notice that it has a default value? Might that then mean that even if you do not supply this parameter then expdp will supply its own? Might that further mean that there is no way to get around the use - explicit or implicit - of an "external directory"?

Personally, if I had been asked that question, I would have challenged the use of the term "external directory". It has no meaning in the Oracle world. The correct term (if this is indeed what they are getting at) is "directory object".

And don't dismiss the possibility that some questions are designed to determine if you can spot a fallacy. And some questions are designed to see if you have the confidence to push back.

Report message to a moderator

Re: Datapump interview question [message #678144 is a reply to message #678128]

Wed, 13 November 2019 02:49

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

Senior Member

And occasionally the interviewer doesn't actually know what they're talking about.

Report message to a moderator

Re: Datapump interview question [message #678153 is a reply to message #678144]

Wed, 13 November 2019 06:41

EdStevens
Messages: 1189
Registered: September 2013

Senior Member

cookiemonster wrote on Wed, 13 November 2019 02:49

And occasionally the interviewer doesn't actually know what they're talking about.

+10

Report message to a moderator

Previous Topic:	Schema export with parallel parameter
Next Topic:	DataPump Export ORA-00922: missing or invalid option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 09 09:47:42 CDT 2020