Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing global name
On Thu, 13 Apr 2000 12:57:37 +0200, "Miha ®nidar¹iè" <miha.znidarsic_at_ixtlan-team.si> wrote:
>We have Oracle 8.1.6. and DB named KIM. In DB global_name is set to
>KIM.ixtlan.si. How can I change it to KIM.ixtlan-team.si?
>
>Our Init.ora file has these values:
>db_name = "KIM"
>db_domain = ixtlan-team.si
>instance_name = KIM
>service_names = KIM.ixtlan-team.si
>
>Thanx, Miha
>
alter database rename global_name to KIM.ixtlan-team.si.
The global database name is in the control file, this is why you don't
see it change when you change the db_domain parameter.
Hth,
Sybrand Bakker, Oracle DBA Received on Thu Apr 13 2000 - 00:00:00 CDT