Scripts and Initialization parameter files

From: Haresh Assumal <assumal_at_sprynet.com>
Date: 1997/09/26
Message-ID: <01bcca96$5f8ccf20$fab1aacc@mycomp.intermediainc.com>#1/1

Hello,
I am new at Orcale, I have worked with Sybase and MS SQL. I am a little confused about scripts and initialization parameter files. I am running Oracle 8 on NT4.0. I have two database and hence two Instances SID=ORCL and SID=TST. First, Is it true that each database has to have its own SID? So far I think this is true. So each database must have its own initialization parameter file. Now when I run a script, say to add a tablespace, how do I specify what database I want to add the tablespace to? Or if I need to add rollback segments how does it know which database I'm refering to?

I may be confused by Sybase/MS SQL Vs Oracle's term of what a "database" is.

I appreciate your input on this.
Thanks,
Haresh
E-mail: assumal_at_sprynet.com Received on Fri Sep 26 1997 - 00:00:00 CDT