Connected to Oracle Database 10g Enterprise Edition Release  10 . 1 . 0 . 5 . 0  
Connected as test


SQL> desc all_tables
Name                      Type         Nullable Default Comments                                                                                   
------------------------- ------------ -------- ------- ------------------------------------------------------------------------------------------ 
OWNER                     VARCHAR2( 30 )                  Owner of the table                                                                         
TABLE_NAME                VARCHAR2( 30 )                  Name of the table                                                                          
TABLESPACE_NAME           VARCHAR2( 30 ) Y                Name of the tablespace containing the table                                                
CLUSTER_NAME              VARCHAR2( 30 ) Y                Name of the cluster, if any, to which the table belongs                                    
IOT_NAME                  VARCHAR2( 30 ) Y                Name of the index-only table, if any, to which the overflow or mapping table entry belongs 
PCT_FREE                  NUMBER       Y                Minimum percentage of free space in a block                                                
PCT_USED                  NUMBER       Y                Minimum percentage of used space in a block                                                
INI_TRANS                 NUMBER       Y                Initial number of transactions                                                             
MAX_TRANS                 NUMBER       Y                Maximum number of transactions                                                             
INITIAL_EXTENT            NUMBER       Y                Size of the initial extent in bytes                                                        
NEXT_EXTENT               NUMBER       Y                Size of secondary extents in bytes                                                         
MIN_EXTENTS               NUMBER       Y                Minimum number of extents allowed in the segment                                           
MAX_EXTENTS               NUMBER       Y                Maximum number of extents allowed in the segment                                           
PCT_INCREASE              NUMBER       Y                Percentage increase in extent size                                                         
FREELISTS                 NUMBER       Y                Number of process freelists allocated in this segment                                      
FREELIST_GROUPS           NUMBER       Y                Number of freelist groups allocated in this segment                                        
LOGGING                   VARCHAR2( 3 )  Y                Logging attribute                                                                          
BACKED_UP                 VARCHAR2( 1 )  Y                Has table been backed up since last modification?                                          
NUM_ROWS                  NUMBER       Y                The number of rows in the table                                                            
BLOCKS                    NUMBER       Y                The number of used blocks in the table                                                     
EMPTY_BLOCKS              NUMBER       Y                The number of empty (never used) blocks in the table                                       
AVG_SPACE                 NUMBER       Y                The average available free space in the table                                              
CHAIN_CNT                 NUMBER       Y                The number of chained rows in the table                                                    
AVG_ROW_LEN               NUMBER       Y                The average row length, including row overhead                                             
AVG_SPACE_FREELIST_BLOCKS NUMBER       Y                The average freespace of all blocks on a freelist                                          
NUM_FREELIST_BLOCKS       NUMBER       Y                The number of blocks on the freelist                                                       
DEGREE                    VARCHAR2( 10 ) Y                The number of threads per instance for scanning the table                                  
INSTANCES                 VARCHAR2( 10 ) Y                The number of instances across which the table is to be scanned                            
CACHE                     VARCHAR2( 5 )  Y                Whether the table is to be cached in the buffer cache                                      
TABLE_LOCK                VARCHAR2( 8 )  Y                Whether table locking is enabled or disabled                                               
SAMPLE_SIZE               NUMBER       Y                The sample size used in analyzing this table                                               
LAST_ANALYZED             DATE         Y                The date of the most recent time this table was analyzed                                   
PARTITIONED               VARCHAR2( 3 )  Y                Is this table partitioned? YES or NO                                                       
IOT_TYPE                  VARCHAR2( 12 ) Y                If index-only table, then IOT_TYPE is IOT or IOT_OVERFLOW or IOT_MAPPING else NULL         
TEMPORARY                 VARCHAR2( 1 )  Y                Can the current session only see data that it place in this object itself?                 
SECONDARY                 VARCHAR2( 1 )  Y                Is this table object created as part of icreate for domain indexes?                        
NESTED                    VARCHAR2( 3 )  Y                Is the table a nested table?                                                               
BUFFER_POOL               VARCHAR2( 7 )  Y                The default buffer pool to be used for table blocks                                        
ROW_MOVEMENT              VARCHAR2( 8 )  Y                Whether partitioned row movement is enabled or disabled                                    
GLOBAL_STATS              VARCHAR2( 3 )  Y                Are the statistics calculated without merging underlying partitions?                       
USER_STATS                VARCHAR2( 3 )  Y                Were the statistics entered directly by the user?                                          
DURATION                  VARCHAR2( 15 ) Y                If temporary table, then duration is sys$session or sys$transaction else NULL              
SKIP_CORRUPT              VARCHAR2( 8 )  Y                Whether skip corrupt blocks is enabled or disabled                                         
MONITORING                VARCHAR2( 3 )  Y                Should we keep track of the amount of modification?                                        
CLUSTER_OWNER             VARCHAR2( 30 ) Y                Owner of the cluster, if any, to which the table belongs                                   
DEPENDENCIES              VARCHAR2( 8 )  Y                Should we keep track of row level dependencies?                                            
COMPRESSION               VARCHAR2( 8 )  Y                Whether table compression is enabled or not                                                
DROPPED                   VARCHAR2( 3 )  Y                Whether table is dropped and is in Recycle Bin                                             

SQL> desc all_views
Name             Type           Nullable Default Comments                                                    
---------------- -------------- -------- ------- ----------------------------------------------------------- 
OWNER            VARCHAR2( 30 )                    Owner of the view                                           
VIEW_NAME        VARCHAR2( 30 )                    Name of the view                                            
TEXT_LENGTH      NUMBER         Y                Length of the view text                                     
TEXT             LONG           Y                View text                                                   
TYPE_TEXT_LENGTH NUMBER         Y                Length of the type clause of the object view                
TYPE_TEXT        VARCHAR2( 4000 ) Y                Type clause of the object view                              
OID_TEXT_LENGTH  NUMBER         Y                Length of the WITH OBJECT OID clause of the object view     
OID_TEXT         VARCHAR2( 4000 ) Y                WITH OBJECT OID clause of the object view                   
VIEW_TYPE_OWNER  VARCHAR2( 30 )   Y                Owner of the type of the view if the view is an object view 
VIEW_TYPE        VARCHAR2( 30 )   Y                Type of the view if the view is an object view              
SUPERVIEW_NAME   VARCHAR2( 30 )   Y                Name of the superview, if view is a subview                 

SQL>