Need help moving Oracle data files

Hi folks. I've "inherited" an Oracle 6 installation on SunOS which is in need of some help. It seems the installers used a hard coded path when defining the additional datafiles. For example, I have:

TSNAME FNAME

-------------  ----------------------------
SYSTEM         /oracle/dbs/dbsoracle1.dbf
SYSTEM         /oracle/dbs/dbsoracle2.dbf

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:

TSNAME FNAME

---------------  -------------------------
SYSTEM           $ORACLE_HOME/dbs/dbsoracle1.dbf

I'm wondering if I can just go in and change this in the database ? (i.e. UPDATE SYSFILES set FNAME = . . . . . .)

I'm hesitant to do so.

Another thought was to export the whole DB, break the thing down and recreate new datafiles with the proper names.

I'm sure this is in the DBA book but I'm at home now .. . . . . :)

Any suggestions ?

Thanks

Rich Holowczak
Rutgers U.
holowcza_at_andromeda.rutgers.edu Received on Tue Dec 07 1993 - 05:25:14 CET