Re: MOVE DATAFILE SCO UNIX possible ?

From: Sean Kubovcik <sean.kubovcik_at_worldnet.att.net>
Date: 1997/01/27
Message-ID: <32ece27f.17218247@netnews.worldnet.att.net>#1/1

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
>
>101756,3156 <-> Compuserve
>101756.3156_at_compuserve.com <-> Internet
>ErikO_at_cmg.nl <-> Internet
Received on Mon Jan 27 1997 - 00:00:00 CST