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

Thread: db name

  1. #11
    Join Date
    Jan 2001
    Posts
    230
    Jeff:

    I tried but I am getting the same error as before.

    Also, when you change the db_name why do I need to do resetlog?

    Thanks.

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [QUOTE][i]Originally posted by ora_inf [/i]
    [B]Jeff:

    I tried but I am getting the same error as before.
    [/B][/QUOTE]
    Check metalink ( [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=1018634.102&p_database_id=NOT[/url] )

    [QUOTE][B]
    Also, when you change the db_name why do I need to do resetlog?
    [/B][/QUOTE]
    Do you need to open resetlogs? No, probably not. I do it because I have just changed a major parameter of my database. Also, that's the way Oracle recommends to do it (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=15390.1 )
    Jeff Hunter

  3. #13
    Join Date
    Jan 2001
    Posts
    230

    Jeff:

    I read the document and check config and init files as suggested. I could not find any ref. old database name.
    When I tried "alter database rename....", did not work. I am getting the same error.
    I am using oracle 8.0.5


    Thanks.

  4. #14
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Not really sure what to tell you. I have done it may times myself. The syntax for alter database is at ( [url]http://technet.oracle.com/doc/server.804/a58225/ch4a.htm#1980962[/url] )
    Jeff Hunter

  5. #15
    Join Date
    Jan 2001
    Posts
    230
    Jeff:

    You are right..It worked. I was replacing global_name with
    my old database name.

    Thanks lot....



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