Hi.

CONNECT sys/password AS SYSDBA
SHUTDOWN IMMEDIATE

-- Move the file to the new location using Windows Explorer

STARTUP MOUNT PFILE=ORACLE_BASE/admin/SID/pfile/init.ora
SELECT name FROM v$datafile;
ALTER DATABASE RENAME FILE 'E:\ORADATA\SID\file.dbf' TO 'F:\ORADATA\SID\file.dbf';
ALTER DATABASE OPEN;

The rename won't work if you put in incorrect stuff so don't worry.

Obviously, substitue you path details. The select is just to remind you.

Sometimes NT/2000 gets a bit funny about moving files unless the service is switched off. If explorer won't let you move the file switch the service off using the services dialog:

Start->Programs->Administrative Tools->Services (2000)
Start->Settings->Control Panel->Services (NT 4.0)

or use:

C:> NET STOP OracleServiceSID

You might want to do a backup before you start. You should definitely backup the controlfile once you've finished.

Have a good one.