Re: I need to change the instance name

2002-05-10 Thread Yechiel Adar
Sorry I meant to say partitioning is not available in SE - not replication. Yechiel Adar Mehish - Original Message - To: [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 3:21 PM Yechiel - Do you have more information (9i and replication)? Previously there was a document on Oracle's

Re: I need to change the instance name (to Dennis)

2002-05-09 Thread Eriovaldo Andrietta
Yechiel : I will take a look at options. Well, for use replication i need to set some parameters, right? So, I didn't do it. It means that i don't use replication. but i will check others otpions. Thanks Regards Eriovaldo - Original Message - To: Multiple recipients of list

Re: I need to change the instance name (to Dennis)

2002-05-07 Thread Eriovaldo Andrietta
Dennis : Thanks for your answer. Well, I need to downgrade my database, changing EE for SE, so ... The most problem is that the v$instance is used in the aplication. I saw in the metalink a document that helps to change the db_name and not the instance_name, understand.. so ... I thought to

Re: I need to change the instance name (to Dennis)

2002-05-07 Thread Yechiel Adar
Right BUT: make sure you do not use any option that does not exist in the standard edition but existed in the enterprise edition. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 12:18 PM Dennis :

RE: I need to change the instance name

2002-05-06 Thread DENNIS WILLIAMS
Eriovaldo - Often the lot of a DBA is to balance value and risk. Here, you must ask yourself - what is the value of retaining the same instance name, and what are the risks to my production environment? If you perceive the value to be high and the risks low, then go for it. But often (especially

Re: I need to change the instance name

2002-05-06 Thread Suzy Vordos
Well, if it's an 8i database and the need exists to change the database name for cosmetic reasons, you could not change anything and simply add DEVELOPER as one of it's service_names in init.ora. Then connections would be accepted as either DEVELOP or DEVELOPER, no surgery required. Eriovaldo

Re: I need to change the instance name

2002-05-05 Thread Eriovaldo Andrietta
Actualy, I am confused, because this is my production environment and I need to get sucess in this operation. It is necessary, and i would like to keep the old name of instance, because i will change the BD version. I think the best way is : 1.) backup the software and datafiles 2.) Export

RE: I need to change the instance name

2002-05-04 Thread Kimberly Smith
Its actually the easiest part. However, I don't want to miss a step so you best running off to Metalink. They actually have a note out there on how to do it. Not quite up to date for 9i but close. You need to shutdown your database, change your oracle sid, rename your init, if using an i

Re: I need to change the instance name

2002-05-04 Thread Ray Stell
On Sat, May 04, 2002 at 03:03:19PM -0800, Kimberly Smith wrote: Its actually the easiest part. However, I don't want to miss a step so you best running off to Metalink. They actually have a note out there on how to do it. Not quite up to date for 9i but close. You need to shutdown your