On a 10g database, there isa default datapump directory created.
Data Pump uses Oracle Directories, so you need to look in dba_directories, or all_directories
if you omit the directory on your datapump job, everything goes to DATA_PUMP_DIR
----- Original Message ----
From: J. Dex <cemail_219_at_hotmail.com>
To: oracle-l_at_freelists.org
Sent: Wednesday, October 17, 2007 10:41:52 AM
Subject: Directory setting for data pump
.hmmessage P
{
margin:0px;padding:0px;}
body.hmmessage
{
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}
How can you find out if a directory has already been created for data pump and the location of the directory? I looked in init parms and didn't see it and looked in system tables and didn't see any reference to it.
Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. Play Now!
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 17 2007 - 11:19:45 CDT
