DBA_TABLES

Previous Next JavaScript must be enabled to correctly display this content

C.21 DBA_TABLES

DBA_TABLES data dictionary for Oracle Database Gateway for SQL Server.

Name	Type	Value
`OWNER`	`VARCHAR2(256)`	-
`TABLE_NAME`	`VARCHAR2(256)`	-
`TABLESPACE_NAME`	`VARCHAR2(1)`	`NULL`
`CLUSTER_NAME`	`VARCHAR2(1)`	`NULL`
`IOT_NAME`	`VARCHAR2(1)`	`NULL`
`PCT_FREE`	`NUMBER`	`0`
`PCT_USED`	`NUMBER`	`0`
`INI_TRANS`	`NUMBER`	`0`
`MAX_TRANS`	`NUMBER`	`0`
`INITIAL_EXTENT`	`NUMBER`	`0`
`NEXT_EXTENT`	`NUMBER`	`0`
`MIN_EXTENTS`	`NUMBER`	`0`
`MAX_EXTENTS`	`NUMBER`	`0`
`PCT_INCREASE`	`NUMBER`	`0`
`FREELISTS`	`NUMBER`	`0`
`FREELIST_GROUPS`	`NUMBER`	`0`
`LOGGING`	`VARCHAR2(1)`	`NULL`
`BACKED_UP`	`VARCHAR2(1)`	`NULL`
`NUM_ROWS`	`NUMBER`	`0`
`BLOCKS`	`NUMBER`	`0`
`EMPTY_BLOCKS`	`NUMBER`	`0`
`AVG_SPACE`	`NUMBER`	`0`
`CHAIN_CNT`	`NUMBER`	`0`
`AVG_ROW_LEN`	`NUMBER`	`0`
`AVG_SPACE_FREELIST_BLOCKS`	`NUMBER`	`0`
`NUM_FREELIST_BLOCKS`	`NUMBER`	`0`
`DEGREE`	`VARCHAR2(1)`	`NULL`
`INSTANCES`	`VARCHAR2(1)`	`NULL`
`CACHE`	`VARCHAR2(1)`	`NULL`
`TABLE_LOCK`	`VARCHAR2(1)`	`NULL`
`SAMPLE_SIZE`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`PARTITIONED`	`VARCHAR2(1)`	`NULL`
`IOT_TYPE`	`VARCHAR2(1)`	`NULL`
`TEMPORARY`	`VARHCAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`
`NESTED`	`VARCHAR2(1)`	`NULL`
`BUFFER_POOL`	`VARCHAR2(1)`	`NULL`
`ROW_MOVEMENT`	`VARCHAR2(1)`	`NULL`
`GLOBAL_STATS`	`VARCHAR2(1)`	`NULL`
`USER_STATS`	`VARCHAR2(1)`	`NULL`
`DURATION`	`VARHCAR2(1)`	`NULL`
`SKIP_CORRUPT`	`VARCHAR2(1)`	`NULL`
`MONITORING`	`VARCHAR2(1)`	`NULL`

Parent topic: Data Dictionary