Note
This view is introduced in V2.2.77.
Purpose
The ALL_OBJECTS view displays all database objects accessible to the current user.
Applicability
This view applies only to the Oracle mode of OceanBase Database.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| OBJECT_NAME | VARCHAR2(128) | NO | The name of the object. |
| SUBOBJECT_NAME | VARCHAR2(128) | NO | The name of the subobject, such as partition. |
| OBJECT_ID | NUMBER | NO | The dictionary object ID of the object. |
| DATA_OBJECT_ID | NUMBER | NO | The dictionary object ID of the segment that contains the object. |
| OBJECT_TYPE | VARCHAR2(23) | NO | The type of the object, such as table, index, partition, package, stored procedure, synonym, or sequence. |
| CREATED | DATE | NO | The time when the object was created. |
| LAST_DDL_TIME | DATE | NO | The time when the object was last modified by using a DDL statement. |
| TIMESTAMP | VARCHAR2(19) | NO | The timestamp specified by the object, which is generated as a character. |
| STATUS | VARCHAR2(7) | NO | The status of the object. Valid values: |
| TEMPORARY | VARCHAR2(1) | NO | Indicates whether the object is a temporary table. |
| GENERATED | VARCHAR2(1) | NO | Indicates whether the name of the object was system-generated. |
| SECONDARY | VARCHAR2(1) | NO | This column is not used. |
| NAMESPACE | NUMBER | NO | The namespace for the object. |
| EDITION_NAME | VARCHAR2(128) | NO | Reserved for future use. |
| SHARING | VARCHAR2(18) | NO | Valid values:DATA LINK: The object is a data link or an object whose data is linked to the root.METADATA LINK: The object is a metadata link or an object whose metadata is linked to the root.EXTENDED DATA LINK: The object is an extended data link or an object whose data link is extended to the root.NONE: None of the above applies. |
| EDITIONABLE | VARCHAR2(1) | NO | Valid values:Y: The object is marked as EDITIONABLE.N: The object is marked as NONEDITIONABLE. |
| ORACLE_MAINTAINED | VARCHAR2(1) | NO | Indicates whether the object is created and maintained by a script provided by Oracle, such as catalog.sql or catproc.sql. Objects with a value of Y in this column can only be modified by running a script provided by Oracle. They cannot be modified in any other ways. |
| APPLICATION | VARCHAR2(1) | NO | Indicates whether the object is a common object for an application. Valid values: |
| DEFAULT_COLLATION | VARCHAR2(1) | NO | The default sorting rule of the object. |
| DUPLICATED | VARCHAR2(1) | NO | Indicates whether the object is duplicated on this shard. Valid values: |
| SHARDED | VARCHAR2(1) | NO | Indicates whether the object is sharded. Valid values: |
| IMPORTED_OBJECT | VARCHAR2(1) | NO | Indicates whether the object has been imported. Valid values: |
| CREATED_APPID | NUMBER | NO | The ID of the application that created the object. |
| CREATED_VSNID | NUMBER | NO | The version ID of the application that created the object. |
| MODIFIED_APPID | NUMBER | NO | The ID of the application that modified the object the last time. |
| MODIFIED_VSNID | NUMBER | NO | The version ID of the application that modified the object the last time. |
Example
obclient [SYS]> SELECT * FROM SYS.ALL_OBJECTS WHERE ROWNUM <= 2;
The query result is as follows:
+-----------+------------------+----------------+-----------+----------------+-------------+-----------+---------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
| OWNER | OBJECT_NAME | SUBOBJECT_NAME | OBJECT_ID | DATA_OBJECT_ID | OBJECT_TYPE | CREATED | LAST_DDL_TIME | TIMESTAMP | STATUS | TEMPORARY | GENERATED | SECONDARY | NAMESPACE | EDITION_NAME | SHARING | EDITIONABLE | ORACLE_MAINTAINED | APPLICATION | DEFAULT_COLLATION | DUPLICATED | SHARDED | IMPORTED_OBJECT | CREATED_APPID | CREATED_VSNID | MODIFIED_APPID | MODIFIED_VSNID |
+-----------+------------------+----------------+-----------+----------------+-------------+-----------+---------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
| oceanbase | __all_core_table | NULL | 1 | 1 | TABLE | 05-JAN-24 | 05-JAN-24 | 05-JAN-24 02.35.02. | VALID | N | N | N | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| oceanbase | __all_table | NULL | 3 | 3 | TABLE | 05-JAN-24 | 05-JAN-24 | 05-JAN-24 02.35.02. | VALID | N | N | N | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+-----------+------------------+----------------+-----------+----------------+-------------+-----------+---------------+---------------------+--------+-----------+-----------+-----------+-----------+--------------+---------+-------------+-------------------+-------------+-------------------+------------+---------+-----------------+---------------+---------------+----------------+----------------+
2 rows in set (0.132 sec)