Datacentre Support Reference Guides
Visit our online shop for ALL your parts, components,
laptops, electronics and gadgets
Logical attribute dba_ views
Are you looking for the most extensive database of internet casinos and online casino games around? You'll find it at Casino Guru Online, as well as some great bonus deals to get you off your feet! | |
| |
- dba_cons_columns
- dba_constraints
- dba_ind_columns
- dba_indexes
- dba_synonyms
- dba_tab_columns
- dba_tables
- dba_views
| | Name | Null? | Type | Name | Null? | Type |
|---|
|
OWNER |
N |
VARCHAR2(30) |
OWNER |
N |
VARCHAR2(30) | |
CONSTRAINT_NAME |
N |
VARCHAR2(30) |
CONSTRAINT_NAME |
N |
VARCHAR2(30) | |
TABLE_NAME |
N |
VARCHAR2(30) |
CONSTRAINT_TYPE |
Y |
VARCHAR2(1) | |
COLUMN_NAME |
Y |
VARCHAR2(4000) |
TABLE_NAME |
N |
VARCHAR2(30) | |
POSITION |
Y |
NUMBER |
SEARCH_CONDITION
| Y |
LONG | | | |
R_OWNER |
Y |
VARCHAR2(30) | | | |
R_CONSTRAINT_NAME
| Y |
VARCHAR2(30) | | | |
DELETE_RULE |
Y |
VARCHAR2(9) | | | |
STATUS |
Y |
VARCHAR2(8) | | | |
DEFERRABLE |
Y |
VARCHAR2(14) | | | |
DEFERRED |
Y |
VARCHAR2(9) | | | |
VALIDATED |
Y |
VARCHAR2(13) | | | |
GENERATED |
Y |
VARCHAR2(14) | | | |
BAD |
Y |
VARCHAR2(3) | | | |
RELY |
Y |
VARCHAR2(4) | | | |
LAST_CHANGE |
Y |
DATE |
| | Name | Null? | Type | Name | Null? | Type |
|---|
|
INDEX_OWNER |
N |
VARCHAR2(30) |
OWNER |
N |
VARCHAR2(30) | |
INDEX_NAME |
N |
VARCHAR2(30) |
INDEX_NAME |
N |
VARCHAR2(30) | |
TABLE_OWNER |
N |
VARCHAR2(30) |
INDEX_TYPE |
Y |
VARCHAR2(27) | |
TABLE_NAME |
N |
VARCHAR2(30) |
TABLE_OWNER |
N |
VARCHAR2(30) | |
COLUMN_NAME |
Y |
VARCHAR2(4000) |
TABLE_NAME |
N |
VARCHAR2(30) | |
COLUMN_POSITION |
N |
NUMBER |
TABLE_TYPE |
Y |
VARCHAR2(11) | |
COLUMN_LENGTH |
N |
NUMBER |
UNIQUENESS |
Y |
VARCHAR2(9) | |
DESCEND |
Y |
VARCHAR2(4) |
COMPRESSION |
Y |
VARCHAR2(8) | | | |
PREFIX_LENGTH |
Y |
NUMBER | | | |
TABLESPACE_NAME |
Y |
VARCHAR2(30) | | | |
INI_TRANS |
Y |
NUMBER | | | |
MAX_TRANS |
Y |
NUMBER | | | |
INITIAL_EXTENT |
Y |
NUMBER | | | |
NEXT_EXTENT |
Y |
NUMBER | | | |
MIN_EXTENTS |
Y |
NUMBER | | | |
MAX_EXTENTS |
Y |
NUMBER | | | |
PCT_INCREASE |
Y |
NUMBER | | | |
PCT_THRESHOLD |
Y |
NUMBER | | | |
INCLUDE_COLUMN |
Y |
NUMBER | | | |
FREELISTS |
Y |
NUMBER | | | |
FREELIST_GROUPS |
Y |
NUMBER | | | |
PCT_FREE |
Y |
NUMBER | | | |
LOGGING |
Y |
VARCHAR2(3) | | | |
BLEVEL |
Y |
NUMBER | | | |
LEAF_BLOCKS |
Y |
NUMBER | | | |
DISTINCT_KEYS |
Y |
NUMBER | | | |
AVG_LEAF_BLOCKS_PER_KEY
| Y |
NUMBER | | | |
AVG_DATA_BLOCKS_PER_KEY
| Y |
NUMBER | | | |
CLUSTERING_FACTOR
| Y |
NUMBER | | | |
STATUS |
Y |
VARCHAR2(8) | | | |
NUM_ROWS |
Y |
NUMBER | | | |
SAMPLE_SIZE |
Y |
NUMBER | | | |
LAST_ANALYZED |
Y |
DATE | | | |
DEGREE |
Y |
VARCHAR2(40) | | | |
INSTANCES |
Y |
VARCHAR2(40) | | | |
PARTITIONED |
Y |
VARCHAR2(3) | | | |
TEMPORARY |
Y |
VARCHAR2(1) | | | |
GENERATED |
Y |
VARCHAR2(1) | | | |
SECONDARY |
Y |
VARCHAR2(1) | | | |
BUFFER_POOL |
Y |
VARCHAR2(7) | | | |
USER_STATS |
Y |
VARCHAR2(3) | | | |
DURATION |
Y |
VARCHAR2(15) | | | |
PCT_DIRECT_ACCESS
| Y |
NUMBER | | | |
ITYP_OWNER |
Y |
VARCHAR2(30) | | | |
ITYP_NAME |
Y |
VARCHAR2(30) | | | |
PARAMETERS |
Y |
VARCHAR2(1000) | | | |
GLOBAL_STATS |
Y |
VARCHAR2(3) | | | |
DOMIDX_STATUS |
Y |
VARCHAR2(12) | | | |
DOMIDX_OPSTATUS |
Y |
VARCHAR2(6) | | | |
FUNCIDX_STATUS |
Y |
VARCHAR2(8) |
| Name | Null? | Type | Name | Null? | Type |
|---|
|
OWNER |
N |
VARCHAR2(30) |
OWNER |
N |
VARCHAR2(30) | |
SYNONYM_NAME |
N |
VARCHAR2(30) |
TABLE_NAME |
N |
VARCHAR2(30) | |
TABLE_OWNER |
Y |
VARCHAR2(30) |
COLUMN_NAME |
N |
VARCHAR2(30) | |
TABLE_NAME |
N |
VARCHAR2(30) |
DATA_TYPE |
Y |
VARCHAR2(106) | |
DB_LINK |
Y |
VARCHAR2(128) |
DATA_TYPE_MOD |
Y |
VARCHAR2(3) | | | |
DATA_TYPE_OWNER |
Y |
VARCHAR2(30) | | | |
DATA_LENGTH |
N |
NUMBER | | | |
DATA_PRECISION |
Y |
NUMBER | | | |
DATA_SCALE |
Y |
NUMBER | | | |
NULLABLE |
Y |
VARCHAR2(1) | | | |
COLUMN_ID |
N |
NUMBER | | | |
DEFAULT_LENGTH |
Y |
NUMBER | | | |
DATA_DEFAULT |
Y |
LONG | | | |
NUM_DISTINCT |
Y |
NUMBER | | | |
LOW_VALUE |
Y |
RAW(32) | | | |
HIGH_VALUE |
Y |
RAW(32) | | | |
DENSITY |
Y |
NUMBER | | | |
NUM_NULLS |
Y |
NUMBER | | | |
NUM_BUCKETS |
Y |
NUMBER | | | |
LAST_ANALYZED |
Y |
DATE | | | |
SAMPLE_SIZE |
Y |
NUMBER | | | |
CHARACTER_SET_NAME
| Y |
VARCHAR2(44) | | | |
CHAR_COL_DECL_LENGTH
| Y |
NUMBER | | | |
GLOBAL_STATS |
Y |
VARCHAR2(3) | | | |
USER_STATS |
Y |
VARCHAR2(3) | | | |
AVG_COL_LEN |
Y |
NUMBER |
| dba_tables | dba_views |
|---|
| Descriptions for all relational tables in the database | Descriptions of all views in the database |
| Name | Null? | Type | Name | Null? | Type |
|---|
|
OWNER |
N |
VARCHAR2(30) |
OWNER |
N |
VARCHAR2(30) | |
TABLE_NAME |
N |
VARCHAR2(30) |
VIEW_NAME |
N |
VARCHAR2(30) | |
TABLESPACE_NAME |
Y |
VARCHAR2(30) |
TEXT_LENGTH |
Y |
NUMBER | |
CLUSTER_NAME |
Y |
VARCHAR2(30) |
TEXT |
Y |
LONG | |
IOT_NAME |
Y |
VARCHAR2(30) |
TYPE_TEXT_LENGTH
| Y |
NUMBER | |
PCT_FREE |
Y |
NUMBER |
TYPE_TEXT |
Y |
VARCHAR2(4000) | |
PCT_USED |
Y |
NUMBER |
OID_TEXT_LENGTH |
Y |
NUMBER | |
INI_TRANS |
Y |
NUMBER |
OID_TEXT |
Y |
VARCHAR2(4000) | |
MAX_TRANS |
Y |
NUMBER |
VIEW_TYPE_OWNER |
Y |
VARCHAR2(30) | |
INITIAL_EXTENT |
Y |
NUMBER |
VIEW_TYPE |
Y |
VARCHAR2(30) | |
NEXT_EXTENT |
Y |
NUMBER | | | | |
MIN_EXTENTS |
Y |
NUMBER | | | | |
MAX_EXTENTS |
Y |
NUMBER | | | | |
PCT_INCREASE |
Y |
NUMBER | | | | |
FREELISTS |
Y |
NUMBER | | | | |
FREELIST_GROUPS |
Y |
NUMBER | | | | |
LOGGING |
Y |
VARCHAR2(3) | | | | |
BACKED_UP |
Y |
VARCHAR2(1) | | | | |
NUM_ROWS |
Y |
NUMBER | | | | |
BLOCKS |
Y |
NUMBER | | | | |
EMPTY_BLOCKS |
Y |
NUMBER | | | | |
AVG_SPACE |
Y |
NUMBER | | | | |
CHAIN_CNT |
Y |
NUMBER | | | | |
AVG_ROW_LEN |
Y |
NUMBER | | | | |
AVG_SPACE_FREELIST_BLOCKS
| Y |
NUMBER | | | | |
NUM_FREELIST_BLOCKS
| Y |
NUMBER | | | | |
DEGREE |
Y |
VARCHAR2(10) | | | | |
INSTANCES |
Y |
VARCHAR2(10) | | | | |
CACHE |
Y |
VARCHAR2(5) | | | | |
TABLE_LOCK |
Y |
VARCHAR2(8) | | | | |
SAMPLE_SIZE |
Y |
NUMBER | | | | |
LAST_ANALYZED |
Y |
DATE | | | | |
PARTITIONED |
Y |
VARCHAR2(3) | | | | |
IOT_TYPE |
Y |
VARCHAR2(12) | | | | |
TEMPORARY |
Y |
VARCHAR2(1) | | | | |
SECONDARY |
Y |
VARCHAR2(1) | | | | |
NESTED |
Y |
VARCHAR2(3) | | | | |
BUFFER_POOL |
Y |
VARCHAR2(7) | | | | |
ROW_MOVEMENT |
Y |
VARCHAR2(8) | | | | |
GLOBAL_STATS |
Y |
VARCHAR2(3) | | | | |
USER_STATS |
Y |
VARCHAR2(3) | | | | |
DURATION |
Y |
VARCHAR2(15) | | | | |
SKIP_CORRUPT |
Y |
VARCHAR2(8) | | | | |
MONITORING |
Y |
VARCHAR2(3) | | | |
|
|
| |
| |