Move the datafile

1.) Move 1 datafile

ALTER DATABASE DATAFILE '<datafile>' OFFLINE;
copy the file in the OS
ALTER DATABASE RENAME FILE '<source_datfile>' TO '<destination_datafile>';
RECOVER DATAFILE '<destination_datafile>';
ALTER DATABASE DATAFILE '<destination_datafile>' ONLINE;

2.) Move more datafile or move SYSTEM,SYSAUX,UNDO

SHUTDOWN IMMEDIATE.
copy the file in the OS
STARTUP MOUNT.
ALTER DATABASE RENAME FILE '<source_datfile>' TO '<destination_datafile>';
...
ALTER DATABASE OPEN.
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License