Re: Alter database rename datafile question
Date: 1996/10/01
Message-ID: <32515FF9.223_at_ionet.net>#1/1
janet wrote:
>
> Hi,
> I'd like to move an entire instance from one logical disk to
> another. It's not a big one, only 5 tablespaces, and 4 of them
> are SYSTEM, RBS, TEMP, and TOOLS.
> Is the move as simple as:
> alter tablespace TBSP_NAME rename datafile '/disk1/system01.dbf' to
> '/disk2/system01.dbf'
> ?????
> (v7.0)
> thanks
> janetHi Janet,
You need to copy or move the file to the new disk drive while the
database is shutdown. Using sqldba startup mount the database. Issue
your alter statement. (I use alter database rename datafile 'old nme' to
'new nme';) After all files are renamed issue alter database open;
That's all there is to it.
hope this helps. Dick Allie - dallie_at_ionet.net
Received on Tue Oct 01 1996 - 00:00:00 CEST