您现在正在浏览：站长之家 >> 数据库 >> 详细内容

ORACLE常见错误代码的分析与解决（三）

时间:2007-11-09 来源:不详作者:迈克DB

的CATEXP.SQL，因而造成视图与Export代码不同步，较难保持彼此之间的兼容，用户就必须建立自己的Export应用，从而
避免ORA-00942的错误。

相应的英文如下：

Cause:The table or view entered does not exist,a synonym that is jnot allowed here was used,or a view was
referenced where a table is required.Existing user tables and views can be listed by querying the data
dictionary.Certain privileges may required to access the table.If an application returned this message,the
table the application tried to access does not exist in the database,or the application does not have
access to it.

Action:Check each of the following:

The spelling of the table or view name.

That a view is not specified where a table is required

That an existing table or view name exists.

Contact the database administrator if the table needs to be created or if user or application priviledes
are required to access the table.

Also, if attempting to access a table or view in another schema,make certain thecorrect schema is 织梦好，好织梦
referenced and that access to the object is granted.

ORA-01598:rollback segment “name” is not online

Cause:The rollback segment was taken offline either manually or by SMON.

Action:Check the status of the rollback segment in DBA_ROLLBACK_SEGS.

ORA-1636: rollback segment “name” is already online

Cause:A rollback segment can only be used by one instance and an instance is trying to bring a rollback
segment online that is already in use.

Action:Check that the values set in the initialization parameter file for parameters
ROLLBACK_SEGMENTS,ROLLBACK_SEGMENT_INITIAL,and ROLLBACK_SEGMENT_COUNT are correctly set for the instance
whiththe problem,Also check that the instance is using the correct initialization parameter file.Make sure
you are not confused about the difference between private and public rollback segments.See the Oracle8
Server Administrator’s Guide for more information about using rollback segments in paraller mode.

上述错误均为我们在使用回滚段时比较常见的问题，ORA-01598指明当前使用的回滚段的状态为“not online”，不能使

用，将它改为“online”状态即可使用；ORA-01636指明当前回滚段已经为“online”状态，可以直接使用，不用再集合
它。

ORA-1636 signalled during: alter rollback segment rb00 online

我们在做统计时还可能遇到下述问题：一个rollback segment的状态为”Needs Recovery”的现象，这是由于ORACLE回退
一个事物表中的没有提交的事物时失败所造成的。通常原因为一个datafile或者tablespace是在offline的状态或者一个
undo的目标被破坏或者rollback segment被破坏。解决的办法是将所有的tablespace和datafile都置为online状态，如果
不能解决则做下面的工作：1>.在initsid.ora中加入event=”10015 trace name context forever lever
10”;2>.shutdown数据库然后重启；3>.在$ORACLE_HOME/rdbms/log下，找到startup时生成的trace file;4>.在trace文件
中，找到下列信息“error recovery tx(#,#) object #”;5>.根据object#(与sys.dba_objects表中的object_id相同)在
sys.dba_objects表中查出该object的名字；6>.将该object drop掉;7>.在init.ora文件中将该rollback segment放回