'Database' 카테고리의 글 목록 (12 Page)

Database

안녕앨리스 2010. 4. 22. 10:17

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

안녕앨리스 2010. 4. 22. 10:14

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

안녕앨리스 2010. 4. 22. 10:13

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

안녕앨리스 2010. 4. 22. 10:12

2010. 4. 22. 10:12

Column Name	Description
CREATED	Timestamp for the creation of the object
DATA_OBJECT_ID	Object number of the segment which contains the object
GENERATED	Was the name of this object system generated?
LAST_DDL_TIME	Timestamp for the last DDL change (including GRANT and REVOKE) to the object
OBJECT_ID	Object number of the object
OBJECT_NAME	Name of the object
OBJECT_TYPE	Type of the object
OWNER	Username of the owner of the object
SECONDARY	Is this a secondary object created as part of icreate for domain indexes?
STATUS	Status of the object
SUBOBJECT_NAME	Name of the sub-object (for example, partititon)
TEMPORARY	Can the current session only see data that it place in this object itself?
TIMESTAMP	Timestamp for the specification of the object

All objects in the database.