Re: Moving SYSTEM data files

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Fri, 22 May 1998 11:32:01 -0400
Message-ID: <6k45pi$5dh@sjx-ixn8.ix.netcom.com>

Yes. You have to use the ALTER DATABASE RENAME FILE command. Shutdown your database. Startup mount and then do ALTER DATABASE rename file 'blab/blah/...' TO
'newblah/newblah/....'. This command changes the name in the control file only. You have to move/copy the file at the OS level before using the command.

HTH
Venkat

Bob B wrote in message <01bd8590$36187800$d66501bc_at_cxymis-15>...
>Is it possible to move the SYSTEM tablespace data files to another
>file system? I'm trying to correct a configuration I inherited & would
>like to move the SYSTEM data files from file system "/p101" to
>"/orasys".
>
>Thanks,
>Bob B
Received on Fri May 22 1998 - 10:32:01 CDT