Re: changing database name

From: I hate Spam <tbf_at_nospam.stam.dk>
Date: 2000/06/30
Message-ID: <su1nlssouqueca7rnhddgo0v2p4iajjvjr@4ax.com>#1/1

On Wed, 28 Jun 2000 10:47:07 +0200, Minas Ghidei <minas.ghidei_at_hsv.se> wrote:

>to me very dangerous.So friends if u have any smart advice to share how
>can i change the database name,sid etc.

export full database (database in restrited mode 1 client, or with consistent=yes)

Create new database with new name
run the catalog and catproc scripts

make an import of the exported data.

If you want to you can create tablespaces before the import with exact same names as in the old database. The locations can be altered to other drives/directories. If not the old datafile structure will be created for you.

Of course if your database is big the export/import could mean a considerable downtime.

Yours Hans Erik Busk
tbf_at_cn.stam.dk Received on Fri Jun 30 2000 - 00:00:00 CDT