export ORACLE_SID=temp2 or ORACLE_SID=temp2 ; export ORACLE_SID HTH GovindanK On Wed, 7 Sep 2005 16:22:59 -0400, "Chirag DBA" <chiragdba@xxxxxxxxx> said: > How will you change the ORACLE_SID in UNIX? > export ORACLE_SID temp2 > echo $ORACLE_SID > temp > What I m missing? > Regards - Chirag -- //www.freelists.org/webpage/oracle-l