Question

moving datafiles to different locations

Backup & recovery, Performance/Tuning

Hi,
Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me.
Regards.

The normal sequence of commands are
alter tablespace [tablespace name] offline;

at OS level move the file to the new location

alter tablespace [tablespace name] rename datafile '[old location & file name]' to '[new location & file name]';
alter tablespace [tablespace name] online;
If recovery is needed just execute the recover tablespace command:
recover tablespace [tablespace name];

replace what is in [] with your information