Posted by Sumit on June 10, 2011
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
Like this:
Be the first to like this post.
Posted in Testing Env., Uncategorized | Tagged: CTAS, MYTAB | 1 Comment »
