Home » RDBMS Server » Server Utilities » DATA_PUMP_DIR confusion ?
DATA_PUMP_DIR confusion ? [message #401860] Wed, 06 May 2009 12:59 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
I was reading the 'Oracle Utilities 10.2' guide and on page 1-11 it states :

On Unix and Windows NT systems, a default directory object, DATA_PUMP_DIR, is created at database creation or whenever the database dictionary is upgraded. By default, it is available only to privileged users.


So based on this do we need to create a directory ?



Eventually it then states :

Do not confuse the default DATA_PUMP_DIR directory object with the client-based
environment variable of the same name.



Can someone explain what this means, cause I am getting confused on this ?
Re: DATA_PUMP_DIR confusion ? [message #401870 is a reply to message #401860] Wed, 06 May 2009 13:20 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
The datapump directory resides on the server. You do not have to create it. Oracle will create a directory object pointing to it. Datapump will use this directory for "pumping" in and out.

I do not know what a client DATA_PUMP_DIR environment variable is.
Re: DATA_PUMP_DIR confusion ? [message #401914 is a reply to message #401870] Wed, 06 May 2009 23:35 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
joy_division wrote on Wed, 06 May 2009 23:50
The datapump directory resides on the server. You do not have to create it.


^^
Where is this location ?
Re: DATA_PUMP_DIR confusion ? [message #401917 is a reply to message #401914] Thu, 07 May 2009 00:24 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
tridentadm wrote on Wed, 06 May 2009 21:35
joy_division wrote on Wed, 06 May 2009 23:50
The datapump directory resides on the server. You do not have to create it.


^^
Where is this location ?



To find it on your system:

SELECT directory_path
FROM all_directories
WHERE directory_name = 'DATA_PUMP_DIR';

example:


1 SELECT directory_path
2 FROM all_directories
3* WHERE directory_name = 'DATA_PUMP_DIR'
SCOTT@orcl_11g> /

DIRECTORY_PATH
--------------------------------------------------------------------------------
C:\app\Barbara\admin\orcl\dpdump\

SCOTT@orcl_11g>

[Updated on: Thu, 07 May 2009 00:27]

Report message to a moderator

Re: DATA_PUMP_DIR confusion ? [message #402018 is a reply to message #401917] Thu, 07 May 2009 05:46 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

DIRECTORY_PATH
--------------------------------------------------------------------------------
C:\app\Barbara\admin\orcl\dpdump\


Backup should be available in server not in client

Babu
Re: DATA_PUMP_DIR confusion ? [message #402067 is a reply to message #402018] Thu, 07 May 2009 08:30 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
gentlebabu wrote on Thu, 07 May 2009 03:46
DIRECTORY_PATH
--------------------------------------------------------------------------------
C:\app\Barbara\admin\orcl\dpdump\


Backup should be available in server not in client

Babu


I am using a laptop running Windows. It is my server.

[Updated on: Thu, 07 May 2009 08:31]

Report message to a moderator

Previous Topic: import on the same user
Next Topic: network_link import doubt ? where does it import to ?
Goto Forum:
  


Current Time: Sun Dec 11 02:00:32 CST 2016

Total time taken to generate the page: 0.19083 seconds