On Sun, Jun 28, 2009 at 8:10 AM, Mubeen Nakade <[email protected]> wrote: > > > Use "set ORACLE_SID=orclrew" instead of "export ORACLE_SID=orclrew" and try. >
There is a difference between set and export. Values assigned by "set" are alive only for the current shell. Values assigned by "export" are alive in the current shell and also all subshells/processes forked by it. Oracle on unix is process-based and all processes need to know the value of ORACLE_SID. Oracle on Winodows is thread based. The set command is used primarily on Windows. Regards, NMK.
