Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rename database

Re: Rename database

From: Shashi Magadi <smagadi_at_yahoo.com>
Date: 4 Oct 2001 12:32:20 -0700
Message-ID: <6acc4fb9.0110041132.29299801@posting.google.com>


you don't need to do an export/import to rename a database. Follow these steps -

  1. ALTER DATABASE BACKUP CONTROLFILE TO TRACE
  2. shutdown database
  3. edit the trace file - CREATE CONTROLFILE REUSE SET DATABASE "Enter New DB name" RESETLOGS NOARCHIVELOG
  4. connect to server manager or sqlplus and start the DB using this edited trace file. "Franky Thiel" <franky.thiel_at_infohos.be> wrote in message news:<3bbc4cd5$0$36471$ba620e4c_at_news.skynet.be>...
    > Is it possible to rename a database or should I do an export from the old
    > database, drop database and recreate new database and do an import ?
    >
    > What is the maximum length of the name of a database in Oracle ?
    >
    >
    >
    > Regards and thanks in advance,
    >
    >
    >
    > Franky
Received on Thu Oct 04 2001 - 14:32:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US