Columns

Constraints

Grants

Statistics

Triggers

Dependencies

Details

Partitions

Indexes


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
ID NUMBER(10,0) Yes null 1 null
CNTYIDFP VARCHAR2(5 BYTE) Yes null 2 null
GEOGRAPHIC_COMPONENT VARCHAR2(2 BYTE) Yes null 3 null
MIN_AGE NUMBER(3,0) Yes null 4 null
MAX_AGE NUMBER(3,0) Yes null 5 null
POPULATION_GT_4 NUMBER(9,0) Yes null 6 null
ENGLISH_ONLY NUMBER(9,0) Yes null 7 null
SPANISH_SPANISH_CREOLE NUMBER(9,0) Yes null 8 null
FRENCH NUMBER(9,0) Yes null 9 null
FRENCH_CREOLE NUMBER(9,0) Yes null 10 null
ITALIAN NUMBER(9,0) Yes null 11 null
PORTUGUESE_PORTUGUESE_CREOLE NUMBER(9,0) Yes null 12 null
GERMAN NUMBER(9,0) Yes null 13 null
YIDDISH NUMBER(9,0) Yes null 14 null
OTHER_WEST_GERMANIC NUMBER(9,0) Yes null 15 null
SCANDINAVIAN NUMBER(9,0) Yes null 16 null
GREEK NUMBER(9,0) Yes null 17 null
RUSSIAN NUMBER(9,0) Yes null 18 null
POLISH NUMBER(9,0) Yes null 19 null
SERBO_CROATIAN NUMBER(9,0) Yes null 20 null
OTHER_SLAVIC NUMBER(9,0) Yes null 21 null
ARMENIAN NUMBER(9,0) Yes null 22 null
PERSIAN NUMBER(9,0) Yes null 23 null
GUJARATHI NUMBER(9,0) Yes null 24 null
HINDI NUMBER(9,0) Yes null 25 null
URDU NUMBER(9,0) Yes null 26 null
OTHER_INDIC NUMBER(9,0) Yes null 27 null
OTHER_INDO_EUROPEAN NUMBER(9,0) Yes null 28 null
CHINESE NUMBER(9,0) Yes null 29 null
JAPANESE NUMBER(9,0) Yes null 30 null
KOREAN NUMBER(9,0) Yes null 31 null
MON_KHMER_CAMBODIAN NUMBER(9,0) Yes null 32 null
MIAO_HMONG NUMBER(9,0) Yes null 33 null
THAI NUMBER(9,0) Yes null 34 null
LAOTIAN NUMBER(9,0) Yes null 35 null
VIETNAMESE NUMBER(9,0) Yes null 36 null
OTHER_ASIAN NUMBER(9,0) Yes null 37 null
TAGALOG NUMBER(9,0) Yes null 38 null
OTHER_PACIFIC_ISLAND NUMBER(9,0) Yes null 39 null
NAVAJO NUMBER(9,0) Yes null 40 null
OTHER_NATIVE_NORTH_AMERICAN NUMBER(9,0) Yes null 41 null
HUNGARIAN NUMBER(9,0) Yes null 42 null
ARABIC NUMBER(9,0) Yes null 43 null
HEBREW NUMBER(9,0) Yes null 44 null
AFRICAN NUMBER(9,0) Yes null 45 null
OTHER_UNSPECIFIED NUMBER(9,0) Yes null 46 null
CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED



Columns


PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
NAME VALUE
NUM_ROWS 25752
BLOCKS 438
AVG_ROW_LEN 110
SAMPLE_SIZE 25752
LAST_ANALYZED 15-DEC-11
LAST_ANALYZED_SINCE 15-DEC-11



Column Statistics


TRIGGER_NAME TRIGGER_TYPE TRIGGER_OWNER TRIGGERING_EVENT STATUS TABLE_NAME




OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 15-DEC-11
LAST_DDL_TIME 15-DEC-11
OWNER SF3_00
TABLE_NAME CO_LANG_AT_HOME_AGE_GT_4
TABLESPACE_NAME STATE_COUNTY_00
CLUSTER_NAME null
IOT_NAME null
STATUS VALID
PCT_FREE 0
PCT_USED null
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 4194304
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
FREELISTS null
FREELIST_GROUPS null
LOGGING NO
BACKED_UP N
NUM_ROWS 25752
BLOCKS 438
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 110
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 25752
LAST_ANALYZED 15-DEC-11
PARTITIONED NO
IOT_TYPE null
OBJECT_ID_TYPE null
TABLE_TYPE_OWNER null
TABLE_TYPE null
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION null
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER null
DEPENDENCIES DISABLED
COMPRESSION ENABLED
COMPRESS_FOR BASIC
DROPPED NO
COMMENTS null
PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE




INDEX_OWNER INDEX_NAME UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS JOIN_INDEX COLUMNS COLUMN_EXPRESSION
SF3_00 CO_LANG_AT_HOME_AGE_UIDX UNIQUE VALID NORMAL N NO null NO CNTYIDFP, GEOGRAPHIC_COMPONENT, MIN_AGE null




INDEX_OWNER INDEX_NAME TABLE_OWNER TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND
SF3_00 CO_LANG_AT_HOME_AGE_UIDX SF3_00 CO_LANG_AT_HOME_AGE_GT_4 CNTYIDFP 1 5 5 ASC
SF3_00 CO_LANG_AT_HOME_AGE_UIDX SF3_00 CO_LANG_AT_HOME_AGE_GT_4 GEOGRAPHIC_COMPONENT 2 2 2 ASC
SF3_00 CO_LANG_AT_HOME_AGE_UIDX SF3_00 CO_LANG_AT_HOME_AGE_GT_4 MIN_AGE 3 22 0 ASC