Below are steps to move the datafiles without shutting down the database.
1. Make the tablespaces offline.
ALTER TABLESPACE tablespace_name offline;
1. Make the tablespaces offline.
ALTER TABLESPACE tablespace_name offline;
2.copy the files to the new location at the OS level
3.Modify the location of the datafiles
ALTER TABLESPACE tablespace_name RENAME DATAFILE 'datafile_name' to 'datafile_name';
ALTER TABLESPACE tablespace_name RENAME DATAFILE 'datafile_name' to 'datafile_name';
4.Make the tablesapces online
ALTER TABLESPACE tablespace_name online;
ALTER TABLESPACE tablespace_name online;
No comments:
Post a Comment