Home » RDBMS Server » Server Utilities » Datapump interview question (Oracle 11g,12c, Unix)
Datapump interview question [message #677078] Fri, 16 August 2019 03:10 Go to next message
BalajiDBA
Messages: 26
Registered: October 2018
Junior Member
Hi,

How to export/import without using external directory?

Can you please answer this datapump question?

Regards,
Balaji
Re: Datapump interview question [message #677084 is a reply to message #677078] Fri, 16 August 2019 09:44 Go to previous messageGo to next message
EdStevens
Messages: 1116
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
Re: Datapump interview question [message #677086 is a reply to message #677078] Fri, 16 August 2019 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 26595
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
Re: Datapump interview question [message #677087 is a reply to message #677078] Fri, 16 August 2019 14:52 Go to previous messageGo to next message
John Watson
Messages: 8009
Registered: January 2010
Location: Global Village
Senior Member
From where are you getting these questions? And what is the motivation for asking?
Re: Datapump interview question [message #677132 is a reply to message #677087] Wed, 21 August 2019 00:09 Go to previous messageGo to next message
BalajiDBA
Messages: 26
Registered: October 2018
Junior Member
This question was asked in interview.
Re: Datapump interview question [message #677135 is a reply to message #677132] Wed, 21 August 2019 06:35 Go to previous message
EdStevens
Messages: 1116
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

Previous Topic: SQL*Loader - wildcard character
Next Topic: oracle solution for sqoop
Goto Forum:
  


Current Time: Wed Sep 18 15:21:12 CDT 2019