Procedure to Move System Datafile
Hi,
I saw the answer to move the system tablespace datafiles.It is not requited to recreate the controlfile.Follow below steps to move the system tablespace datafiles.
1.Shut down the database with immediate or normal option only.
2.copy the datafiles of system tablespace using operating system command to new location porvided that you know the datafiles full path for the system tablespace.Check for both file sizes after copy.
3.Mount the database using command startup mount.
4.Rename the datafile to new file locations.
5.Now open the database.
This procedure used to move the system tablespace datafiles as we can not off line the system tablespace like any other.This procedure will work for all tablespaces.
Note: The database will not be availabel when you perform this operation & before attempting this procedure make a full cold backup of the database.
Thanks,
Ravindra Nimmagadda