Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> create directory using %ORACLE_HOME%

create directory using %ORACLE_HOME%

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: Wed, 28 Aug 2002 17:22:11 -0700
Message-ID: <MPG.17d7090be73de67e989686@news.telepacific.net>


Hi,

I would like to write a script that can accomplish this:

create or replace directory %ORACLE_HOME% || '\FIT_ADMN';

This doesn't work as is. Is there another way to accomplish this?

The %ORACLE_HOME% environment variable seems to have limited use in SQLPLUS and does not work at all in PL/SQL.

Thanks for any help.

-- 
Jim Poe
Fulcrum InteTech, Inc.
<jpoe_at_fulcrumit.com>
Received on Wed Aug 28 2002 - 19:22:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US