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