Re: Need help moving Oracle data files

From: Andrew Finkenstadt <andy_at_vistachrome.com>
Date: Tue, 7 Dec 1993 20:47:17 GMT
Message-ID: <CHon2t.1E2_at_vistachrome.com>


holowcza_at_andromeda.rutgers.edu (Richard D Holowczak) writes:
>It seems the installers
>used a hard coded path when defining the additional datafiles.

Nothing inherently wrong with this. One thing to remember: Oracle's current working directory is always $ORACLE_HOME/dbs and you might be able to use this with good luck:

>For example, I have:
>TSNAME FNAME
>------------- ----------------------------
>SYSTEM /oracle/dbs/dbsoracle1.dbf
>SYSTEM /oracle/dbs/dbsoracle2.dbf

Remember that Sun machines have symbolic links, and that Oracle opens a database file once and keeps it open. Thus there is one symbolic link dereference per database startup, and no overhead thereafter.

>We want to move Oracle on to a new disk with more space.
>I know we can play tricks by mounting the new drive
>under /oracle or something like that. What I'd like to
>do is to somehow assign some new names with a variable
>in place of the path such as:

You definitely want to do "something like that". Move the database files somewhere else, and create a symbolic link from $ORACLE_HOME/dbs/* to the new place. Then you don't have to change the database in any regard at all.

>TSNAME FNAME
>--------------- -------------------------
>SYSTEM $ORACLE_HOME/dbs/dbsoracle1.dbf

No. This will not work. I believe that at one time FORMS & MENU would expand a "?/some/directory" into ORACLE_HOME/some/directory, but I am not assuaged that the kernel would do so for a database filename.

-- 
Andrew Finkenstadt  |  Systems Analyst, Homes & Land Publishing Corporation
+1 904-575-0189     |  GEnie Sysop             ,,,
andy_at_genie.geis.com |                         (. .)     Peek-a-boo!
andy_at_homes.com      +----------------------o00-(_)-00o---------------------
Received on Tue Dec 07 1993 - 21:47:17 CET

Original text of this message