Oracle修改数据文件名以及移动数据文件 - 数据库编程

TOP

Oracle修改数据文件名以及移动数据文件(四)

2017-02-15 08:15:16 【大中小】浏览:803次

adata/orcl/DEV3_UMS.dbf? ? ? DEV3_IAS_UMS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_svctbl.dbf? ? ? DEV3_STB? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_oggmon.dbf? ? ? DEV2_OGGMON? ? ? AVAILABLE ONLINE
/home/oracle/tt_mv.dbf? ? ? TT? ? ? AVAILABLE OFFLINE
/home/oracle/undo02.dbf? ? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
19 rows selected.
sys@ORCL>! mv /home/oracle/tt_mv.dbf /home/oracle/tt_mv2.dbf
! mv /home/oracle/tt_mv.dbf /home/oracle/tt_mv2.dbf
sys@ORCL>! ls -l /home/oracle/tt_mv2.dbf
! ls -l /home/oracle/tt_mv2.dbf
-rw-r----- 1 oracle oinstall 1073750016 Oct 29 08:39 /home/oracle/tt_mv2.dbf
sys@ORCL>alter database rename file '/home/oracle/tt_mv.db';
alter database rename file '/home/oracle/tt_mv.dbf' to '/home/oracle/tt_mv2.dbf';
Database altered.
sys@ORCL>select file_name,tablespace_name,status,online_status from dba_data_files;
select file_name,tablespace_name,status,online_status from dba_data_files;
FILE_NAME? ? ? TABLESPACE_NAME? ? ? STATUSONLINE_
---------------------------------------------------------------------- ------------------------------ --------- -------
/u02/app/oracle/oradata/orcl/users01.dbf? ? ? USERS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/undotbs01.dbf? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/sysaux01.dbf? ? ? SYSAUX? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/system01.dbf? ? ? SYSTEM? ? ? AVAILABLE SYSTEM
/u02/app/oracle/oradata/orcl/DEV_svctbl.dbf? ? ? DEV_STB? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV_ias_opss.dbf? ? ? DEV_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV_iau.dbf? ? ? DEV_IAU? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV_veridata_user.dbf? ? ? DEV_VERIDATA_USER? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_mds.dbf? ? ? DEV3_MDS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_wlsservices.dbf? ? ? DEV3_WLS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_iau.dbf? ? ? DEV3_IAU? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_ias_opss.dbf? ? ? DEV3_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_oggmon.dbf? ? ? DEV3_OGGMON? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_ias_opss.dbf? ? ? DEV2_IAS_OPSS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_UMS.dbf? ? ? DEV3_IAS_UMS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV3_svctbl.dbf? ? ? DEV3_STB? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/DEV2_oggmon.dbf? ? ? DEV2_OGGMON? ? ? AVAILABLE ONLINE
/home/oracle/tt_mv2.dbf? ? ? ? TT? ? ? AVAILABLE OFFLINE
/home/oracle/undo02.dbf? ? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
19 rows selected.
sys@ORCL>alter tablespace tt online;
alter tablespace tt online;
Tablespace altered.
sys@ORCL>select file_name,tablespace_name,status,online_status from dba_data_files;
select file_name,tablespace_name,status,online_status from dba_data_files;
FILE_NAME? ? ? TABLESPACE_NAME? ? ? STATUSONLINE_
---------------------------------------------------------------------- ------------------------------ --------- -------
/u02/app/oracle/oradata/orcl/users01.dbf? ? ? USERS? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/undotbs01.dbf? ? ? UNDOTBS1? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/orcl/sysaux01.dbf? ? ? SYSAUX? ? ? AVAILABLE ONLINE
/u02/app/oracle/oradata/o

首页上一页 1 2 3 4 5 6 下一页尾页 4/6/6
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】

上一篇：MySQL5.6.18解压包版在RHEL6.7上..	下一篇：使用LogMiner分析Oracle的redo日..