Re: How can I change an Instance location ?

From: Brian Everett <brian.everett01_at_home.com>
Date: Mon, 22 Jan 2001 02:58:54 GMT
Message-ID: <mj6n6toi843onhbl6pigdbrmjs5039qaon@4ax.com>

Copy the files over when the database is shutdown. Then mount the database.
Then do some ALTER DATABASE RENAME 'old file spec' to 'new file spec';.
to tell the database where these files have been relocated. Then do a ALTER DATABASE OPEN
to see that it was recorded in the
DBA_DATA_FILES table.

Good Luck!
Brian

On Fri, 19 Jan 2001 11:57:31 +0100, "Fabrice Bachellerie" <fbachellerie_at_scopeland.de> wrote:

>Hi all,
>
>I have one instance on C: and of course not enough place now.... Typical
>newbie...
>
>How can I change this configuration to use E: ?
>
>Thanx
>
>Fabrice
>
Received on Sun Jan 21 2001 - 20:58:54 CST