Re: How to Change Databasename

Erik Oosterling wrote:

> Hello all,
>
> Is there a way to change the database name used in the INIT.ORA
>
> now it is:
>
> DB_NAME = ORACLE
>
> But i want to use
>
> DB_NAME = TEST or
> DB_NAME = PROD
>
> Okay i know you have to the db a name when you create him but it was
> not job to create them but it is my job to support them.
>
> PLEASE HELP
>
> Erik Oosterling
>
> The Netherlands

Hi,

Simply, You cannot change the name of a database (At least up to V7.3.3). The database name is a string of eight characters or less. You name a database during 'create database...' command (As a parameter). This parameter indicates the name of the database, and must match the name used in the CREATE DATABASE statement to be executed in a later step. This name does not have
 to match the SID of the database service. It is recommended that you give a
 unique database name to each database. For example, DB_NAME=ERIK_DB

Regards

Hakan Eren
InfoPower International Inc.
ERP/MRPII/DBMS Consulting and Software Inc. Year 2000 Consulting
Phone:905-507-2100
Fax:905-507-2108
E-mail:hakan_at_infopwr.com

       prabir_at_infopwr.com Received on Thu Jul 31 1997 - 00:00:00 CDT