INSERT INTO REPORT_BASEINFO_TEMP_RSP
SELECT S_COL_ID.NEXTVAL,
CITYCODE,
PHONENUMBER,
GETWAY,
'CMWAP',
NULL,
'1',
decode(COLUMNLEVEL,'99','WAPLOGIN',COLUMNID),
TRIM(COLUMNNAME),
TRIM(COLUMNLEVEL),
STATISTICSTIME
FROM TYWCITY.CMS_STATISTICS_RESOURCE
WHERE TO_CHAR(STATISTICSTIME, 'yyyyMMdd') = '20110727'
AND GETWAY='0'; 3 4 5 6 7 8 9 10 11 12 13 14 15
SELECT S_COL_ID.NEXTVAL,
*
ERROR at line 2:
ORA-00376: file 12 cannot be read at this time
ORA-01111: name for data file 12 is unknown - rename to correct file
ORA-01110: data file 12: '/oracle/product/10.2/dbs/MISSING00012
SELECT S_COL_ID.NEXTVAL,
CITYCODE,
PHONENUMBER,
GETWAY,
'CMWAP',
NULL,
'1',
decode(COLUMNLEVEL,'99','WAPLOGIN',COLUMNID),
TRIM(COLUMNNAME),
TRIM(COLUMNLEVEL),
STATISTICSTIME
FROM TYWCITY.CMS_STATISTICS_RESOURCE
WHERE TO_CHAR(STATISTICSTIME, 'yyyyMMdd') = '20110727'
AND GETWAY='0'; 3 4 5 6 7 8 9 10 11 12 13 14 15
SELECT S_COL_ID.NEXTVAL,
*
ERROR at line 2:
ORA-00376: file 12 cannot be read at this time
ORA-01111: name for data file 12 is unknown - rename to correct file
ORA-01110: data file 12: '/oracle/product/10.2/dbs/MISSING00012
解决方案 »
- Oricle安装问题 急
- 关于pl/sql数据导入导出
- 基础的record问题
- oracle查询,非常的郁闷
- oracle怎样返回修改后的记录列表
- 急救,四年未用Oracle,忘了怎么配了...已找过相关资料
- select * from tb1 where rowid<10; 报错ORA-00932!
- 在线急等```
- PL SQL 登录无法显示数据库名 急!!!
- 请教如何将linux下的oracle数据库以用户的方式备份出来,再导入到nt下的oracle数据库
- 奇怪的问题:求高人看看我的系统是不是被人攻击了~~
- 初学orcale 谁知道如何 把excel里的一列 复制到一个表中的一列 用的pL SQL
alter database rename file 'oracle/product/10.2/dbs/MISSING00012' to '...'; -- 正确的文件名
recover datafile 12;
alter tablespace ... online;
先把它offline掉,然后看能不能恢复把。