startup the db in mount.

execute
alter database rename file 'oldfile' to 'newfile'; -- case sensitive.

Since you have so many files, you will have to use sql to generate your commands.

use something like the following
select 'alter database rename file '''||NAME||''' to '''||replace(name, 'olddrive', 'newdrive')||''';'
from v$datafile;
You may have to tweak this command some for your purposes.

Don't forget your control files (init.ora) & redo logs (v$logfile).

Addendum==> oops, jeff already has it covered.
he has given you a spool example. < spool > just opens up a file in your current directory and writes your output to the file name you give (myfile). Just try it & you;ll see what it does.

d.

[Edited by DBAtrix on 12-22-2000 at 12:06 PM]