| Author |
How to Change SERVICE_NAME in ORACLE 10g
|
jaya kemmannu
Ranch Hand
Joined: Sep 23, 2011
Posts: 72
|
|
Hi,
We have oracle10g installed in redhat linux server. IF my current service_name is set to "XXXX" how can change his to "YYYY". Any help would be appreciated.
Thanks & Regards,
Joy
|
 |
Martin Vajsar
Bartender
Joined: Aug 22, 2010
Posts: 2331
|
|
There is a system parameter you can set: SERVICE_NAMES
See ALTER SYSTEM for details on setting system parameters.
|
 |
Md Haidar Ali Khan
Greenhorn
Joined: Feb 18, 2010
Posts: 12
|
|
ALTER SYSTEM SET SERVICE_NAMES = 'SOMETHINGELSE'
Regards,
MD HAIDAR ALI KHAN
|
 |
 |
|
|
subject: How to Change SERVICE_NAME in ORACLE 10g
|
|
|