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: 58
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: 1148
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: 26643
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: 8085
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: 58
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: 1148
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: 58
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: 58
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: 1148
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