Re: How can I change an Instance location ?

<raas.no_spam_at_interware.hu> wrote in message news:949cf2$rlm$1_at_proxy.interware.hu...
> Fabrice Bachellerie <fbachellerie_at_scopeland.de> wrote:
> > I have one instance on C: and of course not enough place now.... Typical
> > newbie...
>

It's probably because it's Friday, and I've had a very trying Backup and Recovery course in which certain students wouldn't take "walk before you can run" for an answer, but I can't let this one pass:

"I have an Instance on C:...."

NO! You have an Instance floating around in RAM. You have a *database* on C:

Accordingly, you can do *bugger all* to move the location of an Instance. Not unless you fancy delving into a bit of hex and a debugger. You can move your *database* by physically moving the files with O/S commands whilst the database is closed, and then using the 'alter database datafile '/bing/bong/blah.dbf' to 'bong/bing/blah.dbf' command. Finally, alter database open.

Honestly! If you don't know the difference between an Instance and a Database, then it's time to hit the Oracle Press books.

HJR
> first: *** CREATE FULL BACKUP ***
>
> For control files: change their location in init.ora while the DB is
> offline.
>
> For non-SYSTEM tablespaces: (database can be open)
>
> 1. alter tablespace X offline immediate
> 2. move the data files associated w/ that tablespace to their new
> location
> 3. ALTER DATABASE RENAME DATAFILE 'C:\THIS\THAT.DBF' to
> 'D:\OVER\THERE\THAT2.DBF'
> 4. alter tablespace X online
>
> Create a new RBS tablespace, new rollback segments, and drop the old
> ones (taking them offline first).
>
> Create a new temporary tablespace.
>
> for the SYSTEM tablespace, shutdown, startup mount,
> and rename the files.
>
> startup (alter db open), shutdown normal.
>
> when finished, *** CREATE FULL BACKUP ***
>
> regards
> raas
Received on Fri Jan 19 2001 - 07:49:07 CST