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: How to rename a database

Re: How to rename a database

From: Sandy Thrasher <sandra.thrasher_at_MCI2000.com>
Date: 1998/01/25
Message-ID: <lOJy.2007$sd1.264794@news.internetMCI.com>#1/1 







The way I rename the database is the following:



    
  
  1.   Perform a full export of the entire database.
  
  2.   Remove the database - all datafiles, controlfiles, etc...
  
  3.   Recreate the database with a new name.
  
  4.   Import the export file saved in step 1.






This is also a good way to de-fragment your database.  It will improve your
performance for a while...



Sandy
Received on Sun Jan 25 1998 - 00:00:00 CST












Original text of this message













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