ALL_OBJECTSALL_OBJECTS describes all objects accessible to the current user.Related ViewsDBA_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(30) NOT NULL Owner of the object OBJECT_NAME VARCHAR2(30) NOT NULL Name of the object SUBOBJECT_NAME VARCHAR2(30) 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 the Oracle Database assigns to row objects in object tables in the system. OBJECT_TYPE VARCHAR2(19) 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 resulting from a DDL statement (including grants and revokes) TIMESTAMP VARCHAR2(20) Timestamp for the specification of the object (character data) STATUS VARCHAR2(7) Status of the object (VALID, INVALID, or N/A) TEMPORARY VARCHAR2(1) Whether the object is temporary (the current session can see only data that it placed in this object itself) GENERATED VARCHAR2(1) Indicates whether the name of this object was system generated (Y) or not (N) SECONDARY VARCHAR2(1) Whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N)
up...ColumnName ID Data Type Null?OWNER 1 VARCHAR2 (30 Byte) N OBJECT_NAME 2 VARCHAR2 (30 Byte) N SUBOBJECT_NAME 3 VARCHAR2 (30 Byte) Y OBJECT_ID 4 NUMBER N DATA_OBJECT_ID 5 NUMBER Y OBJECT_TYPE 6 VARCHAR2 (19 Byte) Y CREATED 7 DATE N LAST_DDL_TIME 8 DATE N TIMESTAMP 9 VARCHAR2 (19 Byte) Y STATUS 10 VARCHAR2 (7 Byte) Y TEMPORARY 11 VARCHAR2 (1 Byte) Y GENERATED 12 VARCHAR2 (1 Byte) Y SECONDARY 13 VARCHAR2 (1 Byte) Y
OBJECT_NAME --对象名称
SUBOBJECT_NAME
OBJECT_ID --编号
DATA_OBJECT_ID
OBJECT_TYPE --对象类型
CREATED --创建时间
LAST_DDL_TIME --最后ddl操作时间
TIMESTAMP
STATUS --当前状态
TEMPORARY --是否临时的
GENERATED
SECONDARY
OBJECT_NAME: 对象名称
SUBOBJECT_NAME: 子对象名(多用于分区)
OBJECT_ID: 对象ID号
DATA_OBJECT_ID: 包含对象的段ID号
OBJECT_TYPE: 对象类型
CREATED: 对象创建时间
LAST_DDL_TIME: 最后用DDL语句(create,alter,grant,revoke)操作对象的时间
timestamp: 对象标识时间(不太理解,一般和created一样)
STATUS: 对象状态:VALID(有效),INVALID(无效)
TEMPORARY: 是否临时对象
GENERATED: 名字是否系统产生的
SECONDARY: 是否由ODCIIndexCreate 对象方法产生的第二个对象(通常没有用处)。
OWNER VARCHAR2(30) NOT NULL Owner of the object
OBJECT_NAME VARCHAR2(30) NOT NULL Name of the object
SUBOBJECT_NAME VARCHAR2(30) 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 the Oracle Database assigns to row objects in object tables in the system.
OBJECT_TYPE VARCHAR2(19) 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 resulting from a DDL statement (including grants and revokes)
TIMESTAMP VARCHAR2(20) Timestamp for the specification of the object (character data)
STATUS VARCHAR2(7) Status of the object (VALID, INVALID, or N/A)
TEMPORARY VARCHAR2(1) Whether the object is temporary (the current session can see only data that it placed in this object itself)
GENERATED VARCHAR2(1) Indicates whether the name of this object was system generated (Y) or not (N)
SECONDARY VARCHAR2(1) Whether this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N)
up...ColumnName ID Data Type Null?OWNER 1 VARCHAR2 (30 Byte) N
OBJECT_NAME 2 VARCHAR2 (30 Byte) N
SUBOBJECT_NAME 3 VARCHAR2 (30 Byte) Y
OBJECT_ID 4 NUMBER N
DATA_OBJECT_ID 5 NUMBER Y
OBJECT_TYPE 6 VARCHAR2 (19 Byte) Y
CREATED 7 DATE N
LAST_DDL_TIME 8 DATE N
TIMESTAMP 9 VARCHAR2 (19 Byte) Y
STATUS 10 VARCHAR2 (7 Byte) Y
TEMPORARY 11 VARCHAR2 (1 Byte) Y
GENERATED 12 VARCHAR2 (1 Byte) Y
SECONDARY 13 VARCHAR2 (1 Byte) Y
支持,dba_tables, all_tables, user_tables.怎么字段都不一样。