Mytab Table

Mytab structure :- CTAS dba_objects

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

Session1>@tableinfo
enter table name :- mytab

INDEX_NAME                     COLUMN_NAME                              COLUMN_POSITION
------------------------------ ---------------------------------------- ---------------
MYTAB_IDX                      OWNER                                                  1
MYTAB_IDX                      OBJECT_NAME                                            2
MYTAB_IDX                      SUBOBJECT_NAME                                         3
MYTAB_IDX2                     GENERATED                                              1

(Size) Mb       Size(Gb)
----------     ----------
3581.5      3.49755859