Re: Moving Datafiles

Relocating datafiles? You don't have to recreate the controlfile. The following steps should do it for you.

1. Alter tablespace <whatever name> offline;
2. Now at Operating system prompt actually move the datafiles to new location(s).
3. Alter tablespace rename datafile <'/path/filename' (of oldfile)> to <'/path/filename' (of newfile)>; This command with associate the controlfile with new datafile.
4. Alter Tablespace <whatever name> online;

Hope this will help you.

Sugu
In article <33F1359D.96255D2C_at_cyberway.com.sg>,   John Li <johnli_at_cyberway.com.sg> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet