Oracle教程 2023-02-23

Oracle 视图 ALL_OBJECTS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_OBJECTS可以用来查询关于当前用户拥有权限的所有数据库对象（表、索引、视图、序列、存储过程、触发器）。可以使用它来查询以下内容：

1. 数据库对象的名称；
2. 数据库对象所属的架构名称；
3. 数据库对象的类型；
4. 最后一次对对象进行DML操作的时间戳；
5. 数据库对象的状态；
6. 数据库对象的状态信息；
7. 数据库对象的Comments；
8. 数据库对象的Storage 表。

如果要使用ALL_OBJECTS，可以使用如下SQL语句：

SELECT *
FROM all_objects
WHERE owner = ‘USER’
AND object_type = ‘TABLE’
AND object_name = ‘TABLE_NAME’;

官方英文解释

ALL_OBJECTS describes all objects accessible to the current user.

Related Views

DBA_OBJECTS describes all objects in the database.
USER_OBJECTS describes all objects owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`SUBOBJECT_NAME`	`VARCHAR2(128)`		Name of the subobject (for example, partition)
`OBJECT_ID`	`NUMBER`	`NOT NULL`	Dictionary object number of the object
`DATA_OBJECT_ID`	`NUMBER`		Dictionary object number of the segment that contains the object. Note: `OBJECT_ID` and `DATA_OBJECT_ID` display data dictionary metadata. Do not confuse these numbers with the unique 16-byte object identifier (object ID) that Oracle Database assigns to row objects in object tables in the system.
`OBJECT_TYPE`	`VARCHAR2(23)`		Type of the object (such as `TABLE`, `INDEX`)
`CREATED`	`DATE`	`NOT NULL`	Timestamp for the creation of the object
`LAST_DDL_TIME`	`DATE`	`NOT NULL`	Timestamp for the last modification of the object and dependent objects resulting from a DDL statement (including grants and revokes)
`TIMESTAMP`	`VARCHAR2(19)`		Timestamp for the specification of the object (character data)
`STATUS`	`VARCHAR2(7)`		Status of the object: `VALID` `INVALID` `N/A`
`TEMPORARY`	`VARCHAR2(1)`		Indicates whether the object is temporary (the current session can see only data that it placed in this object itself) (`Y`) or not (`N`)
`GENERATED`	`VARCHAR2(1)`		Indicates whether the name of this object was system-generated (`Y`) or not (`N`)
`SECONDARY`	`VARCHAR2(1)`		Indicates whether this is a secondary object created by the `ODCIIndexCreate` method of the Oracle Data Cartridge (`Y`) or not (`N`)
`NAMESPACE`	`NUMBER`	`NOT NULL`	Namespace for the object
`EDITION_NAME`	`VARCHAR2(128)`		Name of the edition in which the object is actual
`SHARING`	`VARCHAR2(18)`		Values: `DATA` `LINK` – If the object is data-linked or a data link to an object in the root `METADATA` `LINK` – If the object is metadata-linked or a metadata link to an object in the root `EXTENDED` `DATA` `LINK` – If the object is extended-data-linked or an extended data link to an object in the root `NONE` – If none of the above applies
`EDITIONABLE`	`VARCHAR2(1)`		Values: `Y` – For objects marked EDITIONABLE `N` – For objects marked NONEDITIONABLE `NULL` – For objects whose type is not editionable in the database
`ORACLE_MAINTAINED`	`VARCHAR2(1)`		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 `Y` must not be changed in any way except by running an Oracle-supplied script.
`APPLICATION`	`VARCHAR2(1)`		Indicates whether the object is an Application common object (`Y`) or not (`N`)
`DEFAULT_COLLATION`	`VARCHAR2(100)`		Default collation for the object
`DUPLICATED`	`VARCHAR2(1)`		Indicates whether this object is duplicated on this shard (`Y`) or not (`N`)
`SHARDED`	`VARCHAR2(1)`		Indicates whether this object is sharded (`Y`) or not (`N`)
`IMPORTED_OBJECT`	`VARCHAR2(1)`		Indicates whether this object is imported (`Y`) or not (`N`)
`CREATED_APPID`	`NUMBER`		ID of the Application that created the object
`CREATED_VSNID`	`NUMBER`		ID of the Application Version that created the object
`MODIFIED_APPID`	`NUMBER`		ID of the Application that last modified the object
`MODIFIED_VSNID`	`NUMBER`		ID of the Application Version that last modified the object

本站中文解释

官方英文解释

相关推荐