Re: Moving Datafiles

John Li wrote:
>
> Is it possible to recreate the control file with the new locations of
> the data files?
>
> ie. after connecting as internal, run "alter database backup controlfile
> to trace". This will create a .trc file in the log directory. Can I then
> edit this file after moving the data file/s and then use this file to
> recreate the control file?
>
> I have only tried this method to increate the value of maxdatafiles but
> not to relocate datafiles and I've always wonder whether it can be done
> that way.
>
> John

Yes, it will work.
Halina Received on Wed Aug 13 1997 - 00:00:00 CDT