parameter to sql script
Hi all,
on 11.2.0.4 on Windows 2008 server
I run a script :
sql>@0-createdb.sql MYDBNAME
In which :
startup nomount pfile=%ORACLE_HOME%\database\init&1.ora
But when running I receive :
SQL> startup nomount pfile=%ORACLE_HOME%\database\init&1.ora
LRM-00109: could not open parameter file 'C:\app\administrateur\product\11.2.0\dbhome_1\database\initMYDBNAMEora'
ORA-01078: failure in processing system parameters
How should I write %ORACLE_HOME%\database\init&1.ora in my script to preserve dot befor ora ?
Thank you.