As for mobile data files, you can do this for System Table Space 1. Shutdown 2.copy the systemdata file to / u02 3.startup Mount 4.alter Database Rename DataFile ... TO ... 5. ALTER DATABASE OPEN For ordinary table space 1.alTer TableSpace ... offline 2.copy datafile to / u02 3.aTER DATABASE RENAME DATAFILE ... TO ... 4.ALTER TABLESPACE ... ONLINE
You can shutdown Database, then build a connection, then startup Database, there is no need to move CTL, which is one of the advantages compared to NT.
