Re: Alter database rename datafile question

Robert Kent wrote:
>
> janet <janet_at_telesph.com> 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'

All u have to do is as follows
1) Shut the database down clean.

2) Copy the database files to the new location.  

3) Startup nomount

4) Issue the following command

   Alter database rename file 'old_file1' ,'old_file2' ...

                      to 'new_file1' ,'new_file2' ... ;

5) Alter database open.

-- 

Regards,

Varad Acharya