I agree Jared..!! I knew the simple export thing and that didn work so I put here. I know that guys don mind in answering create table queries too. I will surely take care of this. Thanx Regards - Chirag On 9/7/05, Jared Still <jkstill@xxxxxxxxx> wrote: > > That would be the Bourne shell, which requires a different syntax. > > set ORACLE_SID=admdevs4; export ORACLE_SID > > Or, heaven forbid, the C shell, which requires aspirin. > > May I make a suggestion for Chirag? Find a good book on > the use of Shell (ksh, bash, whatever) and work through the > examples so that you understand it. > > No one (well, almost no one) minds answering simple questions > here, but it is understood that due diligence on the part of the > poster would be to first attempt to learn the technology you are > having trouble with. > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > 11+ years of trying to appear to know what I'm doing. > > On 9/7/05, David Sharples <davidsharples@xxxxxxxxx> wrote: > > > > what shell are you using on what OS? > > > > On 9/7/05, Chirag DBA <chiragdba@xxxxxxxxx > wrote: > > > > > > What m I missing? > > > > > > $ export ORACLE_SID=admdevs4 > > > ORACLE_SID=admdevs4: is not an identifier > > > $ export ORACLE_SID admdevs4 > > > $ echo $ORACLE_SID > > > > > > > > >