All Objects

Three new columns have appeared in ALL_OBJECTS, and object names can now be up to 128 characters. I haven't been able to create any tables with more than 30 character names, and have yet to find any objects in the data dictionary with names exceeding 30 characters in length.

Oracle 11		Oracle 12
Name Null? Type --------------------------- -------- ------------- OWNER NOT NULL VARCHAR2(30) OBJECT_NAME NOT NULL VARCHAR2(30) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NOT NULL NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED NOT NULL DATE LAST_DDL_TIME NOT NULL DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) NAMESPACE NOT NULL NUMBER EDITION_NAME VARCHAR2(30)		Name Null? Type --------------------------- -------- ------------- OWNER NOT NULL VARCHAR2(128) OBJECT_NAME NOT NULL VARCHAR2(128) SUBOBJECT_NAME VARCHAR2(128) OBJECT_ID NOT NULL NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(23) CREATED NOT NULL DATE LAST_DDL_TIME NOT NULL DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) NAMESPACE NOT NULL NUMBER EDITION_NAME VARCHAR2(128) SHARING VARCHAR2(13) EDITIONABLE VARCHAR2(1) ORACLE_MAINTAINED VARCHAR2(1)

Oracle 11

Oracle 12

 Name                        Null?    Type
 --------------------------- -------- -------------
 OWNER                       NOT NULL VARCHAR2(30)
 OBJECT_NAME                 NOT NULL VARCHAR2(30)
 SUBOBJECT_NAME                       VARCHAR2(30)
 OBJECT_ID                   NOT NULL NUMBER
 DATA_OBJECT_ID                       NUMBER
 OBJECT_TYPE                          VARCHAR2(19)
 CREATED                     NOT NULL DATE
 LAST_DDL_TIME               NOT NULL DATE
 TIMESTAMP                            VARCHAR2(19)
 STATUS                               VARCHAR2(7)
 TEMPORARY                            VARCHAR2(1)
 GENERATED                            VARCHAR2(1)
 SECONDARY                            VARCHAR2(1)
 NAMESPACE                   NOT NULL NUMBER
 EDITION_NAME                         VARCHAR2(30)

 Name                        Null?    Type
 --------------------------- -------- -------------
 OWNER                       NOT NULL VARCHAR2(128)
 OBJECT_NAME                 NOT NULL VARCHAR2(128)
 SUBOBJECT_NAME                       VARCHAR2(128)
 OBJECT_ID                   NOT NULL NUMBER
 DATA_OBJECT_ID                       NUMBER
 OBJECT_TYPE                          VARCHAR2(23)
 CREATED                     NOT NULL DATE
 LAST_DDL_TIME               NOT NULL DATE
 TIMESTAMP                            VARCHAR2(19)
 STATUS                               VARCHAR2(7)
 TEMPORARY                            VARCHAR2(1)
 GENERATED                            VARCHAR2(1)
 SECONDARY                            VARCHAR2(1)
 NAMESPACE                   NOT NULL NUMBER
 EDITION_NAME                         VARCHAR2(128)
 SHARING                              VARCHAR2(13)
 EDITIONABLE                          VARCHAR2(1)
 ORACLE_MAINTAINED                    VARCHAR2(1)