How to move or rename datafile in oracle database
ORACLE:How to move or rename datafile in oracle database
--get tablespace name and datafile location
set pages 999 long 999 lines 999
col TABLESPACE_NAME for a15
col file_name for a40
select tablespace_name,file_name,file_id,bytes/1024/1024 from dba_data_files order by 1;
--offline the datafile
alter database datafile '/u02/oradata/dbtech/dbtechts1.dbf' offline;
--move or rename datafile at os level
mv /u02/oradata/dbtech/dbtechts1.dbf /u01/dbtechts1.dbf
--rename datafile at DB level
alter tablespace DBTECHTS rename datafile '/u02/oradata/dbtech/dbtechts1.dbf' to '/u01/dbtechts1.dbf';
--online the datafile
alter database datafile '/u01/dbtechts1.dbf' online;