Re: How to specify SID during db creation?

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Tue, 18 May 1999 09:52:19 -0400
Message-ID: <374170e9.0@news.mountain.net>

A SID is just an Environment Variable that Oracle uses to find the files. So to create a new one just ORACLE_SID=ORCL2; export ORACLE_SID

Kenny Gump

ewong74_at_netscape.net wrote in message <7hr0tv$n4f$1_at_nnrp1.deja.com>...
>Hi,
>
>I am running Oracle 8.05 on Solaris 2.6. I have an old db instance 'ORCL'
>with db block 2k. I am now trying to create a new db instance 'ORCL2' with
>4k block size. I would like to know how to specify instance name(SID) when
I
>create a new db?? There is only 'db_name' in the init file and I don't
think
>I can specify it in 'Create database' statement. Thanks.
>
>BTW, what's the difference between db_name and SID?
>
>Ed
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Tue May 18 1999 - 08:52:19 CDT