Re: Need help moving Oracle data files
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