filmov
tv
How to move or rename datafile in oracle database
![preview_player](https://i.ytimg.com/vi/iJIoVAea-lk/maxresdefault.jpg)
Показать описание
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
--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