各位大大,我已经在网上找了很多关于ORA-01578和ORA-011110错误如何解决的帖子,但是从收集的资料知道出现ORA-01578和ORA-011110错误问题需要根据具体的出错情况来采取相应措施.
我今次遇到的情况如下:
ORACLE10g版本,在新建一个JOB时出现错误提示ORA-01578和ORA-011110,其中ORA-01578的FILE_ID = 1,数据块号是1658;ORA-011110错误,指明是SYSTEM01.DBF.执行以下语句:
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE
FROM DBA_EXTENTS
WHERE FILE_ID = 1
AND 1658 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
得到结果为:
OWNER SEGMENT_NAME SEGMENT_TYPE
SYS JOB$ TABLE请各位大大帮帮忙!谢谢!
我今次遇到的情况如下:
ORACLE10g版本,在新建一个JOB时出现错误提示ORA-01578和ORA-011110,其中ORA-01578的FILE_ID = 1,数据块号是1658;ORA-011110错误,指明是SYSTEM01.DBF.执行以下语句:
SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE
FROM DBA_EXTENTS
WHERE FILE_ID = 1
AND 1658 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
得到结果为:
OWNER SEGMENT_NAME SEGMENT_TYPE
SYS JOB$ TABLE请各位大大帮帮忙!谢谢!
where values for file and block are from the message.Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Support Services.ORA-01111 name for data file string is unknown - rename to correct fileCause: The datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file that was saved before the file was created.Action: Rename the MISSING file to the name of the real file.Oracle 92中是这样描述的,看是否对你有些帮助
先谢谢了,我也看过帮助文件了,感觉用处不大的说...