Hi

It is possible to move the datafile and redo logfile without using export/import.

Step1: Take a control file backup, using "alter database backup controlfile to trace"

Step2: Take the backup of your full db (for safer side).

Step3: Shutdown DB

Step4: Move the Datafile and log file to new location (where u want).

Step5: Create a new Controlfile script, using the backup controlfile and change the Path to new location.

Step6: Startup the Listener Service alone from services
Startup nomount from svrmgr

Step7: Execute the Controlfile script

Step8: Execute "Alter database open resetlogs"

Step9: Thats it...


Hope this will help you...

Regards