Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to set a global database name?
To show your global DB name:
select * from global_name;
To change it:
alter database rename global_name to SALES.MIRL.COM.TW;
/Rune
Hilbert wrote:
> According to Oracle's documentation, a database's global database name is
> comprised of two parts:
> a name component (DB_NAME) and a network domain component (DB_DOMAIN).
>
> For example, if DB_NAME = sales and DB_DOMAIN = mirl.com.tw,
> the global database name is sales.mirl.com.tw.
>
> I have set the DB_NAME and DB_DOMAIN to the above values in parameter file.
> But the results retrieved by "select * from global_name;" is sales.world.
> (world is the default value of DB_DOMAIN)
>
> Is there any thing wrong? How to change the DB_DOMAIN of a database?
> (I am running Oracle 7.3.3 on NT.)
>
> Thanks !
Received on Tue Mar 31 1998 - 00:00:00 CST