전체 글
- 천삼백케이 10주년 이벤트 2010.04.22
- USER_CONS_COLUMNS 2010.04.22
- DBA_USERS 2010.04.22
- DBA_TABLESPACES 2010.04.22
천삼백케이 10주년 이벤트
2010. 4. 22. 10:26
USER_CONS_COLUMNS
2010. 4. 22. 10:17
| Column Name | Description |
|---|---|
| COLUMN_NAME | Name associated with column or attribute of object column specified in the constraint definition |
| CONSTRAINT_NAME | Name associated with the constraint definition |
| OWNER | Owner of the constraint definition |
| POSITION | Original position of column or attribute in definition |
| TABLE_NAME | Name associated with table with constraint definition |
Information about accessible columns in constraint definitions
'Database > Oracle' 카테고리의 다른 글
| 비-트리 인덱스(B-Tree Index) (0) | 2010.04.27 |
|---|---|
| Db file sequential read (0) | 2010.04.26 |
| DBA_USERS (0) | 2010.04.22 |
| DBA_TABLESPACES (0) | 2010.04.22 |
| DBA_OBJECTS (0) | 2010.04.22 |
DBA_USERS
2010. 4. 22. 10:14
Column Name
Description
ACCOUNT_STATUS
CREATED
User creation date
DEFAULT_TABLESPACE
Default tablespace for data
EXPIRY_DATE
EXTERNAL_NAME
User external name
INITIAL_RSRC_CONSUMER_GROUP
User's initial consumer group
LOCK_DATE
PASSWORD
Encrypted password
PROFILE
User resource profile name
TEMPORARY_TABLESPACE
Default tablespace for temporary tables
USERNAME
Name of the user
USER_ID
ID number of the user
'Database > Oracle' 카테고리의 다른 글
| Db file sequential read (0) | 2010.04.26 |
|---|---|
| USER_CONS_COLUMNS (0) | 2010.04.22 |
| DBA_TABLESPACES (0) | 2010.04.22 |
| DBA_OBJECTS (0) | 2010.04.22 |
| Hash Partition (0) | 2010.04.12 |
DBA_TABLESPACES
2010. 4. 22. 10:13
Column Name
Description
ALLOCATION_TYPE
Type of extent allocation in effect for this tablespace
BLOCK_SIZE
Tablespace block size
CONTENTS
Tablespace contents: "PERMANENT", or "TEMPORARY"
DEF_TAB_COMPRESSION
Default compression enabled or not: "ENABLED" or "DISABLED"
EXTENT_MANAGEMENT
Extent management tracking: "DICTIONARY" or "LOCAL"
FORCE_LOGGING
Tablespace force logging mode
INITIAL_EXTENT
Default initial extent size
LOGGING
Default logging attribute
MAX_EXTENTS
Default maximum number of extents
MIN_EXTENTS
Default minimum number of extents
MIN_EXTLEN
Minimum extent size for the tablespace
NEXT_EXTENT
Default incremental extent size
PCT_INCREASE
Default percent increase for extent size
PLUGGED_IN
SEGMENT_SPACE_MANAGEMENT
Segment space management tracking: "AUTO" or "MANUAL"
STATUS
Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY"
TABLESPACE_NAME
Tablespace name
'Database > Oracle' 카테고리의 다른 글
| USER_CONS_COLUMNS (0) | 2010.04.22 |
|---|---|
| DBA_USERS (0) | 2010.04.22 |
| DBA_OBJECTS (0) | 2010.04.22 |
| Hash Partition (0) | 2010.04.12 |
| 오라클 기본 용어들 (0) | 2010.04.08 |