Re: Scripts and Initialization parameter files

1. yes,
2. yes,
3. Any objects you create or reference (assuming no database links) will be part of the database or instance you are logged into. So if you are logged into tst, and create a tablespace it will be part of the tst database. If connecting locally, change your oracle SID before logging in using the set command. For example, if you want to use instance "tst" at the command line, type: set ORACLE_SID=tst if you are using sqlplus: sqlplus system/manager to see what database you are using: SQL>select * from v$database;

    If connecting remotely using sqlnet just specify sqlnet service name defined in tnsnames.ora

    sqlplus system/manager_at_tst

Also, look at you registry settings for ORACLE_SID, there is probably a default SID of orcl assigned. You can change your SID there also.

Haresh Assumal wrote:

> 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