Re: CHANGING LOCATIONS DATAFILES

From: Don Vick <dvick_at_lanier.com>
Date: Wed, 18 Jan 1995 19:03:04 GMT
Message-ID: <D2M7L5.HIJ_at_lanier.com>

In article <3fhblm$qj4_at_dcsun4.us.oracle.com>, Sunil Mushran <smushran_at_us.oracle.com> wrote:
>To move datfiles...Use ALTER DATABASE RENAME FILE ... TO ...;
>
>Make sure the tablespace is offline or db is only
>mounted (not opened).
> etc

If you are on a Unix system, you should use links for your datafile names. If you need to move a datafile, just offline it, move the file, change the link, and online the datafile. Oracle only knows the file by the link name, so it will happily use the file in its new location.

---

Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com) Voice: (404) 493-2194 Fax: (404) 493-2399 Received on Wed Jan 18 1995 - 20:03:04 CET