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 -> Re: create directory using %ORACLE_HOME%

Re: create directory using %ORACLE_HOME%

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


In article <MPG.17d7090be73de67e989686_at_news.telepacific.net>, jpoe_at_fulcrumit.com says...
> 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.
>
>

Excuse me. I'm on Oracle 8.1.7, running on W2K.

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

Original text of this message

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