You set your Oracle instance variable in UNIX and export it before you
enter svrmgrl to create your database: $ORACLE_SID=ORCL2 and each instance
of Oracle should have its own initSID.ora parameter file located in
$ORACLE_HOME/dbs. You could also re-create the ORCL database to change the
blocksize and import the data to bring it back to the same point in time if
all the data will fit in a single export file. You can still do it if the
database is too big it just involves more work.
ewong74_at_netscape.net wrote in article <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 - 13:37:10 CDT
