Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create directory using %ORACLE_HOME%
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