怎么解决Oracle12c中空格引发的ORA-01516问题

Oracle12cORA-01516 2019129zabbix10:02:22 SQL> col file_name for a5010:02:42 SQL> select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name=’&ts’ order by 1;Enter value for ts: TBS_LOGIDXold 1: select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name=’&ts’ order by 1new 1: select file_id,tablespace_name,file_name,bytes/1024/1024/1免费云主机域名024 G from dba_data_files where tablespace_name=’TBS_LOGIDX’ order by 1 FILE_ID TABLESPACE_NAME FILE_NAME G———- ———————– ————————————————– ———- 2 TBS_LOGIDX /u01/app/oracle/oradata/DLOG/tbs_logix01.dbf 31.9999847 18 TBS_LOGIDX /u01/app/oracle/oradata/DLOG/tbs_logix02.dbf 31.9570313 19 TBS_LOGIDX /u01/app/oracle/oradata/DLOG/tbs_unvidx03.dbf 31.95703133 rows selected.Elapsed: 00:00:00.01
12.2http://blog.itpub.net/31480688/viewspace-2214095/10:05:03 SQL> alter /*source only*/ database move datafile ‘/u01/app/oracle/oradata/DLOG/tbs_unvidx03.dbf’ to ‘/u01/app/oracle/oradata/DLOG/tbs_logix03.dbf’;alter /*source only*/ database move datafile ‘/u01/app/oracle/oradata/DLOG/tbs_unvidx03.dbf’ to ‘/u01/app/oracle/oradata/DLOG/tbs_logix03.dbf’*ERROR at line 1:ORA-01516: nonexistent log file, data file, or temporary file “/u01/app/oracle/oradata/DLOG/tbs_unvidx03.dbf” in the current container
oracle@ORADB-14417: /u01/app/oracle/oradata/DLOG$ ls -lrt tbs_unvi*
-rw-r—– 1 oracle oinstall 1073750016 Jan 29 10:13 tbs_unvidx01.dbf-rw-r—– 1 oracle oinstall 34313609216 Jan 29 10:13 tbs_unvidx03.dbf
v$datafile10:07:29 SQL> select name,status from v$datafile where file#=19;NAME——————–STATUS———————/u01/app/oracle/oradata/DLOG/tbs_unvidx03.dbfONLINE1 row selected.Elapsed: 00:00:00.02 Oraclefile_id10:14:09 SQL> alter /*source only*/ database move datafile 19 to ‘/u01/app/oracle/oradata/DLOG/tbs_logix03.dbf’;Database altered.Elapsed: 00:11:41.37
toad

CRTOracle12cORA-01516

相关推荐: 使用Redis的相关知识点有哪些

本篇内容主要讲解“使用Redis的相关知识点有哪些”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“使用Redis的相关知识点有哪些”吧!速度快，因为数据存在内存中，类似于HashMap，HashMap的优势就是查找和…