本站中文解释
Oracle视图DBA_INVALID_OBJECTS记录在连接数据库中存在无效对象，这些无效对象无法被访问，可能在前一次补丁或建立操作期间出现问题。可以使用此视图来发现任何无效对象，以便及时修复它们。
要使用DBA_INVALID_OBJECTS，需要执行以下步骤：
1.登录到Oracle数据库，使用用户名和密码打开「SQL Plus」控制台。
2.使用以下Select语句来查询DBA_INVALID_OBJECTS视图：
SELECT * FROM DBA_INVALID_OBJECTS;
3.将查询结果保存到文件中，方便以后查询与比较：
SPOOL .txt
4.执行Alter语句可以修复无效对象：
ALTER OBJECT
5.步骤2到步骤4的执行完成之后，可以再次运行步骤2的查询语句检查结果，以确认更改是否已生效。
官方英文解释
DBA_INVALID_OBJECTS describes all invalid objects in the database. You can use this view to identify invalid objects before and after a database upgrade.
This view eliminates old versions of object types. It only includes the object type it if is the latest version.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the object |
|
|
|
|
Name of the object |
|
|
|
|
Name of the subobject (for example, partition) |
|
|
|
|
Dictionary object number of the object. |
|
|
|
|
Dictionary object number of the segment that contains the object. Note: |
|
|
|
|
Type of the object (such as The current version of the type is shown only if it is invalid. In other words, if prior versions of the type are invalid but the most recent version of the type is valid, it will not be in this list. |
|
|
|
|
Timestamp for the creation of the object |
|
|
|
|
Timestamp for the last modification of the object and dependent objects resulting from a DDL statement (including grants and revokes) |
|
|
|
|
Timestamp for the specification of the object (character data) |
|
|
|
|
Status of the object:
|
|
|
|
|
Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) ( |
|
|
|
|
Indicates whether the name of this object was system-generated ( |
|
|
|
|
Indicates whether this is a secondary object created by the |
|
|
|
|
Namespace for the object |
|
|
|
|
Name of the edition in which the object is actual |
|
|
|
|
Values:
|
|
|
|
|
Values:
|
|
|
|
|
Denotes whether the object was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). An object for which this column has the value |
|
|
|
|
Indicates whether the object is an Application common object ( |
|
|
|
|
Default collation for the object |
|
|
|
|
Indicates whether this object is duplicated on this shard ( |
|
|
|
|
Indicates whether this object is sharded ( |
|
|
|
|
Indicates whether this object is imported ( |
|
|
|
|
ID of the Application that created the object |
|
|
|
|
ID of the Application Version that created the object |
|
|
|
|
ID of the Application that last modified the object |
|
|
|
|
ID of the Application Version that last modified the object |
