| DATA_PUMP_DIR confusion ? [message #401860] |
Wed, 06 May 2009 12:59  |
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  |
joy_division
Messages: 4963
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 #401917 is a reply to message #401914] |
Thu, 07 May 2009 00:24 |
 |
Barbara Boehmer
Messages: 9090
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 #402067 is a reply to message #402018] |
Thu, 07 May 2009 08:30 |
|
Barbara Boehmer
Messages: 9090
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
