Your statement is wrong and confusing people on this list "... you
should not change the db name after database creation mena say first db
name was DHW and after creation your changing to some thing like DBDHW
then it wont work database will not start"...

That is totally false. There is NO reason you cannot change the
database name as much as you want. You need to understand the
implications to any apps or software that might access it but.. Oracle
could care less how often you rename. I do it nearly daily for test
purposes and have done so since the beginning of Oracle. Please get
your facts straight before making such statements.

M

>>> "Rahul " <oracledba-ezmlmshield-x69557142.[Email address protected]
03/29/05 11:19 PM >>>
hi there,
yes!!! you can change the db name in any case after
creating
the database
but you should not change the db name after database creation mena say
first
db name was DHW and after creation your changing to some thing like
DBDHW
then it wont work database will not start

and if you want to do these thing then you need to create controlfile
by
create controlfile command
................

Regards
Rahul Chaudhari


----- Original Message -----
From: "Sajid Iqbal "
<oracledba-ezmlmshield-x33938750.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, March 24, 2005 3:10 PM
Subject: dbname


>
> Are the Instance_name and db_name parameters in the init file
case
> sensitive ?
>
> Can I change them to be lower case ? without it affecting anything ?
>
> Regards
>
> Sa
>
>
****************************************************************************
****
> This e-mail and any files transmitted with it are confidential and
intended
> soley for the use of the individual to whom it is addressed. Any
views
or
> opinions presented are soley those of the author and do not
necessarily
> represent those of City College Manchester.
>
> If you are not the intended recipient, please be advised that you
have
> received this e-mail in error and that any use, dissemination,
forwarding,
> printing, or copying of this e-mail is stricty prohibited.
>
>
****************************************************************************
****
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page