Home -> Usenet -> comp.databases.oracle -> Alter database rename datafile question

Alter database rename datafile question

From: janet <janet_at_telesph.com>
Date: 1996/10/01
Message-ID: <32513610.659E_at_telesph.com>#1/1 







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


janet
Received on Tue Oct 01 1996 - 00:00:00 CEST












Original text of this message