Restriction on Database Name - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Restriction on Database Name

  1. #11
    Join Date
    Nov 2000
    Posts
    205
    Actually I will be creating a new development and QA system (with appropriate names), in production I will be changing the name maybe in a month or too. Highly nervous to do it but determined to do it.. How bad can it be anyway if I have a cold backup?

    So to understand, the steps are:
    -- recreate controlfile with resetlogs option
    -- edit scripts use the set command
    -- edit the initfiles with appropriate names
    -- run the create controlfile
    -- change global names etc

    Right?

    Nirasha

  2. #12
    Join Date
    Feb 2001
    Posts
    40
    Yeah u got it.

    But u have to use the set command in the control file.

    I hope it works. But if u want to create the instance u can do it using the ORADIM utility and change the instance name also.

    Karthi

  3. #13
    Join Date
    Nov 2000
    Posts
    205
    What really bothers me is that the instance name states fndryd (in the init.ora), but not when I select from the data dictionary views.

    Nirasha

  4. #14
    Join Date
    Feb 2001
    Posts
    40
    I think that the Instance name that is given for the database will be shown clearly in the V$Instance. The database has the instance value as per the v$Instance view. So try recreating the Instance with a different name and let the same name remain in the Init file. I havent done that but it is a suggestion.

  5. #15
    Join Date
    Nov 2000
    Posts
    205
    Will do as soon as I finish prepare a development system, so that I can play with their dev system when it is done. SInce I will be converting that to a qa system.

    Thanks for your help,
    Nirasha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width