Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting dpdump location during Oracle 11g DB creation with DBCA....

richard evansAug 4 2010 — edited Aug 4 2010

I'm hoping someone can point me to an init parameter or environment variable I can set to change the default location of the Data Pump DATA_PUMP_DIR directory.

I'm running Solaris 10 and KSH so I tried setting it as an environment... no luck.

export ORACLE_SID=DXA1
export ORACLE_BASE=/oracle/$ORACLE_SID
export ORACLE_HOME=$ORACLE_BASE/112_64
export DATA_PUMP_DIR=/oracle/DXA1/oratrace/dpdump

dbca -silent -createDatabase -gdbName $ORACLE_SID -templateName /group/oracle/install/11201_General_Purpose.dbc -sysPassword test1234 -systemPassword test1234

Copying database files
1% complete
Creating and starting Oracle instance
40% complete
62% complete
Completing Database Creation
66% complete
100% complete
Look at the log file "/oracle/DXA1/cfgtoollogs/dbca/DXA1/DXA1.log" for further details.

SQL> select * from dba_directories where directory_name = 'DATA_PUMP_DIR';

OWNER DIRECTORY_NAME DIRECTORY_PATH
--------- ------------------------------ ---------------------------------------------
SYS DATA_PUMP_DIR /oracle/DXA1/admin/DXA1/dpdump/

I'd prefer to set this up front so I don't have to re-configure it for each new database installation. It's not a big deal... I just want it where I want it :-)

Thanks in advance!

Regards,
Rich