Re: SERVICE_NAME

zeb wrote:
> Thanks for the answer...
>
> > Have you looked into upgrading the database in place?
> I think it will take more time, more than one hour
> so it isn't a issue

Have you tested to see if the exp/imp that you want to do can fit inside your downtime window of 30 minutes?

>
> > Otherwise, shutdown the old db and start the version 9.2.0.5 db
using
> > the same service name.
> How can I do that ?
> The name of the service is different ...
> can I change the service name somewhere ?

C:\> oradim -edit -sid current_sid -newsid new_sid Oradim can be found in ORACLE_HOME\bin directory. Just typing oradim without any parameters prints usage.

>
> > If you have to restart the old db later change
> > its SID and Service Name.

Regards
/Rauf Received on Wed Feb 16 2005 - 18:32:21 CST