DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to rename the database

  1. #1
    Join Date
    Jul 2001
    Posts
    1
    Could any body tell me how to rename the database.

    Thanks in Advance


    Jas

  2. #2
    Join Date
    Sep 2001
    Location
    Bangalore, India
    Posts
    1
    use the following command:

    ALTER DATABASE RENAME TO

  3. #3
    Join Date
    Jun 2001
    Location
    Hyderabad
    Posts
    18
    i dont think so we can change the database name once it is created but the only think we can do is change the dbname if it is a part of domain by this command
    alter database db-name global rename to domainname.db-name ;
    correct me if i am wrong

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    i think you have posted the query in the wrong forum.

    comming back to your question to rename a database.backup your control file .

    alter database backup controlfile to trace.....
    edit this controlfile to change the name of the database.
    now use startup command...and you have sucessfully renmaed your database.

    be careful to take a complete backup of your database before you attempt this.

    regards
    Hrishy

  5. #5
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    ok what i did :

    1)alter database backup controlfile to trace;
    2)edit that trace file replacing "reuse" with "set" as well as
    "noresetlogs" to resetlogs"...of course make sure your new dbname is changed.
    3)chg ur init.ora
    4)remove the "recover database ..." in the trace file then run it!

    it should work!

    rgds,
    ngwh,
    Singapore.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Concerning renaming a database, check Metalink Doc ID: 61590.1


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