Re: Moving Oracle database files

The previous posting has a few errors so here she is...

1.) shutdown the database

2.) backup your database

3.) move your data files to the new location

4.) startup mount

5.) alter database rename file 'old' to 'new'

5.) alter database open

good luck, Robert Prendin
Douglas Scott <Douglas.S.Scott_at_boeing.com> wrote:

>We just got an Alpha 2100 with a disk array and are going to cluster it
>with our VAX 6000 so that the disks can be used from either machine. I
>would like to move some of my database files onto the new disks. Can
>anyone tell me what is the easiest way to move Oracle database files?
>
>Douglas Scott
>Douglas.S.Scott_at_boeing.com
>
Received on Sun Feb 01 1998 - 00:00:00 CST