C.24 DBA_TABLES

DBA_TABLES data dictionary for Oracle Database Gateway for Sybase.

Name Type Value

OWNER

VARCHAR2(30)

-

TABLE_NAME

VARCHAR2(30)

-

TABLESPACE_NAME

CHAR(1)

" "

CLUSTER_NAME

CHAR(1)

" "

IOT_NAME

CHAR(1)

" "

PCT_FREE

NUMBER(10)

0

PCT_USED

NUMBER(10)

0

INI_TRANS

NUMBER(10)

0

MAX_TRANS

NUMBER(10)

0

INITIAL_EXTENT

NUMBER(10)

0

NEXT_EXTENT

NUMBER(10)

0

MIN_EXTENTS

NUMBER(10)

0

MAX_EXTENTS

NUMBER(10)

0

PCT_INCREASE

NUMBER(10)

0

FREELISTS

NUMBER(10)

0

FREELIST_GROUPS

NUMBER(10)

0

LOGGING

CHAR(1)

" "

BACKED_UP

CHAR(1)

" "

NUM_ROWS

NUMBER(10)

0

BLOCKS

NUMBER(10)

0

EMPTY_BLOCKS

NUMBER(10)

0

AVG_SPACE

NUMBER(10)

0

CHAIN_CNT

NUMBER(10)

0

AVG_ROW_LEN

NUMBER(10)

0

AVG_SPACE_FREELIST_BLOCKS

NUMBER(10)

0

NUM_FREELIST_BLOCKS

NUMBER(10)

0

DEGREE

CHAR(1)

" "

INSTANCES

CHAR(1)

" "

CACHE

CHAR(1)

" "

TABLE_LOCK

CHAR(1)

" "

SAMPLE_SIZE

NUMBER(10)

0

LAST_ANALYZED

DATE

NULL

PARTITIONED

CHAR(1)

" "

IOT_TYPE

CHAR(1)

" "

TEMPORARY

CHAR(1)

" "

SECONDARY

CHAR(1)

" "

NESTED

CHAR(1)

" "

BUFFER_POOL

CHAR(1)

" "

ROW_MOVEMENT

CHAR(1)

" "

GLOBAL_STATS

CHAR(1)

" "

USER_STATS

CHAR(1)

" "

DURATION

CHAR(1)

" "

SKIP_CORRUPT

CHAR(1)

" "

MONITORING

CHAR(1)

" "