Re: How to rename a database

From: Raymond K.W. Lau <raymdlau_at_hk.super.net>
Date: 1998/01/26
Message-ID: <6afqkl$aa1$1@tst.hk.super.net>#1/1

Thanks ! It works. But it sounds a little bit complicated ! I want a shortcut to make it.
Sometimes I import back the full export into a new database, errors will pop up !!

Sandy Thrasher wrote in message ...
>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 Mon Jan 26 1998 - 00:00:00 CST