Re: How to change location of ...

Lutz Marten (marten_at_ilt.fhg.de) wrote:

: Hello,
: can anyone tell me how to change the location for the database and redo-log files in unix. E.g.:
: The current location ist /usr/oracle/dbs/dbsoracle.dbf and I want to change them to /usr/oki/doki/dbsoracle.dbf and the same for log1 and log2 .

Have a look at the ALTER DATABASE RENAME FILE commands in your DBA guide for the exact syntax. First copy the files to the new location (actually first shutdown the database), then rename the files with the aforementioned command and then restart the database.

A quick and dirty way is to use symbolic links instead.

• These opinions (if any) are just mine. I do not represent Oracle ---
• Corporation in this Posting ---

Sandor Nieuwenhuijs
Oracle Netherlands Received on Fri Jul 23 1993 - 12:13:15 CEST