Re: How can I change an Instance location ?

Why move the files?

Make sure the existing files have autoextend=false, add a datafile to each tablespace on the e: drive, and voilets :} the databse has the additional space.

In article <mj6n6toi843onhbl6pigdbrmjs5039qaon_at_4ax.com>,   Brian Everett <brian.everett01_at_home.com> wrote:
>
> 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
> >
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com
http://www.deja.com/