Re: MOVE DATAFILE SCO UNIX possible ?

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/01/28
Message-ID: <mjrE4ozqx.3DC@netcom.com>#1/1

In article <32ED3F98.699C_at_nightmare.com>, oracle <oracle_at_nightmare.com> wrote:
>Sean Kubovcik wrote:
>>
>> Try:
>> Take tablespace offline
>> At OS, copy old file to new file system
>> Run: alter database 'old /dir/file' to 'new /dir/file';
>> Put tablespace online
>> Test
>> Delete old file
>> Reference page 7-13 of the Oracle7 Server Admin Guide, 'Renaming and
>> relocating data files'.
>> Sean
>>
>> >Hello,
>> >
>> >i made a small mistake. I made a datafile on the wrong disk, is it
>> >possible to move this to the right place.
>> >
>> >Please HELP !!!!!!!!!!!!!!!!!
>> >
>> >
>> >BTW it is a part of the system tablespace.
>> >
>> >Greatings,
>> >
>> >Erik Oosterling
>> >
>
>I think you would need to do:
>
> alter database rename file 'oldfile' to 'newfile'

You can also try a symbolic link

ln -s newfile oldfile

It is best to create the link in the directory of the oldfile and use full path.

hope this helps

Mark Rosenbaum			Otey-Rosenbaum & Frazier, Inc.
mjr_at_netcom.com			Consultants in High Performance and
(303) 727-7956			Scalable Computing and Applications
POB 1397			ftp://ftp.netcom.com/pub/mj/mjr/resume/

Boulder CO 80306 Received on Tue Jan 28 1997 - 00:00:00 CST