Re: Using symbolic links for data files ??
Date: Wed, 21 Dec 1994 14:50:26 GMT
Message-ID: <D16184.G8v_at_lanier.com>
In article <1994Dec19.152251.487_at_cho006>,
Chris Little <little_c_at_cho006.cho.ge.com> wrote:
>Running Oracle 7.0.16 on HP-UX 9.04
>
>My intention is create symbolic links in this directory which
>point to data files distributed across multiple disks. This way,
>if I need to move a file, I can take the tablespace offline,
>move the file, modify the link, and bring the tablespace back
>online again, without having to ALTER TABLESPACE RENAME DATAFILE...
>
>This approach would also seem beneficial for backup and recovery
>because all symbolic links for a database are in a single directory.
>
We are running multiple Oracle instances on three machines, and we do this on all our databases. It simplifies a lot of maintenance operations, and makes it easy to see at a glance what files are included in a database. Our platforms are Sequents with ptx, Oracle 6.0.36 and 7.0.16.
Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com) Voice: (404) 493-2194 Fax: (404) 493-2399 Received on Wed Dec 21 1994 - 15:50:26 CET