VIEW: SYS.DBA_ALL_TABLES

Source

View Text - Preformatted

select OWNER, TABLE_NAME, TABLESPACE_NAME, CLUSTER_NAME, IOT_NAME, STATUS,
     PCT_FREE, PCT_USED,
     INI_TRANS, MAX_TRANS,
     INITIAL_EXTENT, NEXT_EXTENT,
     MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE,
     FREELISTS, FREELIST_GROUPS, LOGGING,
     BACKED_UP, NUM_ROWS, BLOCKS, EMPTY_BLOCKS,
     AVG_SPACE, CHAIN_CNT, AVG_ROW_LEN,
     AVG_SPACE_FREELIST_BLOCKS, NUM_FREELIST_BLOCKS,
     DEGREE, INSTANCES, CACHE, TABLE_LOCK,
     SAMPLE_SIZE, LAST_ANALYZED, PARTITIONED,
     IOT_TYPE, NULL, NULL, NULL, TEMPORARY, SECONDARY, NESTED,
     BUFFER_POOL, FLASH_CACHE,
     CELL_FLASH_CACHE, ROW_MOVEMENT,
     GLOBAL_STATS, USER_STATS, DURATION, SKIP_CORRUPT, MONITORING,
     CLUSTER_OWNER, DEPENDENCIES, COMPRESSION, COMPRESS_FOR, DROPPED,
     SEGMENT_CREATED,
     INMEMORY, INMEMORY_PRIORITY, INMEMORY_DISTRIBUTE, INMEMORY_COMPRESSION,
     INMEMORY_DUPLICATE
from dba_tables
union all
select "OWNER","TABLE_NAME","TABLESPACE_NAME","CLUSTER_NAME","IOT_NAME","STATUS","PCT_FREE","PCT_USED","INI_TRANS","MAX_TRANS","INITIAL_EXTENT","NEXT_EXTENT","MIN_EXTENTS","MAX_EXTENTS","PCT_INCREASE","FREELISTS","FREELIST_GROUPS","LOGGING","BACKED_UP","NUM_ROWS","BLOCKS","EMPTY_BLOCKS","AVG_SPACE","CHAIN_CNT","AVG_ROW_LEN","AVG_SPACE_FREELIST_BLOCKS","NUM_FREELIST_BLOCKS","DEGREE","INSTANCES","CACHE","TABLE_LOCK","SAMPLE_SIZE","LAST_ANALYZED","PARTITIONED","IOT_TYPE","OBJECT_ID_TYPE","TABLE_TYPE_OWNER","TABLE_TYPE","TEMPORARY","SECONDARY","NESTED","BUFFER_POOL","FLASH_CACHE","CELL_FLASH_CACHE","ROW_MOVEMENT","GLOBAL_STATS","USER_STATS","DURATION","SKIP_CORRUPT","MONITORING","CLUSTER_OWNER","DEPENDENCIES","COMPRESSION","COMPRESS_FOR","DROPPED","SEGMENT_CREATED","INMEMORY","INMEMORY_PRIORITY","INMEMORY_DISTRIBUTE","INMEMORY_COMPRESSION","INMEMORY_DUPLICATE" from dba_object_tables

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, TABLESPACE_NAME
, CLUSTER_NAME
, IOT_NAME
, STATUS
, PCT_FREE
, PCT_USED
, INI_TRANS
, MAX_TRANS
, INITIAL_EXTENT
, NEXT_EXTENT
, MIN_EXTENTS
, MAX_EXTENTS
, PCT_INCREASE
, FREELISTS
, FREELIST_GROUPS
, LOGGING
, BACKED_UP
, NUM_ROWS
, BLOCKS
, EMPTY_BLOCKS
, AVG_SPACE
, CHAIN_CNT
, AVG_ROW_LEN
, AVG_SPACE_FREELIST_BLOCKS
, NUM_FREELIST_BLOCKS
, DEGREE
, INSTANCES
, CACHE
, TABLE_LOCK
, SAMPLE_SIZE
, LAST_ANALYZED
, PARTITIONED
, IOT_TYPE
, NULL
, NULL
, NULL
, TEMPORARY
, SECONDARY
, NESTED
, BUFFER_POOL
, FLASH_CACHE
, CELL_FLASH_CACHE
, ROW_MOVEMENT
, GLOBAL_STATS
, USER_STATS
, DURATION
, SKIP_CORRUPT
, MONITORING
, CLUSTER_OWNER
, DEPENDENCIES
, COMPRESSION
, COMPRESS_FOR
, DROPPED
, SEGMENT_CREATED
, INMEMORY
, INMEMORY_PRIORITY
, INMEMORY_DISTRIBUTE
, INMEMORY_COMPRESSION
, INMEMORY_DUPLICATE FROM DBA_TABLES UNION ALL SELECT "OWNER"
, "TABLE_NAME"
, "TABLESPACE_NAME"
, "CLUSTER_NAME"
, "IOT_NAME"
, "STATUS"
, "PCT_FREE"
, "PCT_USED"
, "INI_TRANS"
, "MAX_TRANS"
, "INITIAL_EXTENT"
, "NEXT_EXTENT"
, "MIN_EXTENTS"
, "MAX_EXTENTS"
, "PCT_INCREASE"
, "FREELISTS"
, "FREELIST_GROUPS"
, "LOGGING"
, "BACKED_UP"
, "NUM_ROWS"
, "BLOCKS"
, "EMPTY_BLOCKS"
, "AVG_SPACE"
, "CHAIN_CNT"
, "AVG_ROW_LEN"
, "AVG_SPACE_FREELIST_BLOCKS"
, "NUM_FREELIST_BLOCKS"
, "DEGREE"
, "INSTANCES"
, "CACHE"
, "TABLE_LOCK"
, "SAMPLE_SIZE"
, "LAST_ANALYZED"
, "PARTITIONED"
, "IOT_TYPE"
, "OBJECT_ID_TYPE"
, "TABLE_TYPE_OWNER"
, "TABLE_TYPE"
, "TEMPORARY"
, "SECONDARY"
, "NESTED"
, "BUFFER_POOL"
, "FLASH_CACHE"
, "CELL_FLASH_CACHE"
, "ROW_MOVEMENT"
, "GLOBAL_STATS"
, "USER_STATS"
, "DURATION"
, "SKIP_CORRUPT"
, "MONITORING"
, "CLUSTER_OWNER"
, "DEPENDENCIES"
, "COMPRESSION"
, "COMPRESS_FOR"
, "DROPPED"
, "SEGMENT_CREATED"
, "INMEMORY"
, "INMEMORY_PRIORITY"
, "INMEMORY_DISTRIBUTE"
, "INMEMORY_COMPRESSION"
, "INMEMORY_DUPLICATE"
FROM DBA_OBJECT_TABLES