How to move or rename datafile in oracle database

preview_player
Показать описание
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

--move or rename datafile at os level

--rename datafile at DB level

--online the datafile
Рекомендации по теме