Re: Use of Temp Table and Two DB problem

no temp table in oracle 7.X

When you create your second database, are you changing the environment variable ORACLE_SID. The oracle_sid will tell oracle which init file to use at startup. I hope this answers your question, if no please provide more info like OS and the commands you are using

Regards,

Richard Fuoco

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet