티스토리 뷰

데이터베이스/오라클

오라클 DBA VIEW

쌀맛나는세상 2008. 1. 15. 16:41
DBA_TAB_COLS

Column Name ID Data Type Null? Comments
OWNER 1 VARCHAR2 (30 Byte) N 　
TABLE_NAME 2 VARCHAR2 (30 Byte) N Table, view or cluster name
COLUMN_NAME 3 VARCHAR2 (30 Byte) N Column name
DATA_TYPE 4 VARCHAR2 (106 Byte) Y Datatype of the column
DATA_TYPE_MOD 5 VARCHAR2 (3 Byte) Y Datatype modifier of the column
DATA_TYPE_OWNER 6 VARCHAR2 (30 Byte) Y Owner of the datatype of the column
DATA_LENGTH 7 NUMBER N Length of the column in bytes
DATA_PRECISION 8 NUMBER Y Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE 9 NUMBER Y Digits to right of decimal point in a number
NULLABLE 10 VARCHAR2 (1 Byte) Y Does column allow NULL values?
COLUMN_ID 11 NUMBER Y Sequence number of the column as created
DEFAULT_LENGTH 12 NUMBER Y Length of default value for the column
DATA_DEFAULT 13 LONG Y Default value for the column
NUM_DISTINCT 14 NUMBER Y The number of distinct values in the column
LOW_VALUE 15 RAW (32) Y The low value in the column
HIGH_VALUE 16 RAW (32) Y The high value in the column
DENSITY 17 NUMBER Y The density of the column
NUM_NULLS 18 NUMBER Y The number of nulls in the column
NUM_BUCKETS 19 NUMBER Y The number of buckets in histogram for the column
LAST_ANALYZED 20 DATE Y The date of the most recent time this column was analyzed
SAMPLE_SIZE 21 NUMBER Y The sample size used in analyzing this column
CHARACTER_SET_NAME 22 VARCHAR2 (44 Byte) Y Character set name
CHAR_COL_DECL_LENGTH 23 NUMBER Y Declaration length of character type column
GLOBAL_STATS 24 VARCHAR2 (3 Byte) Y Are the statistics calculated without merging underlying partitions?
USER_STATS 25 VARCHAR2 (3 Byte) Y Were the statistics entered directly by the user?
AVG_COL_LEN 26 NUMBER Y The average length of the column in bytes
CHAR_LENGTH 27 NUMBER Y The maximum length of the column in characters
CHAR_USED 28 VARCHAR2 (1 Byte) Y C if the width was specified in characters, B if in bytes
V80_FMT_IMAGE 29 VARCHAR2 (3 Byte) Y Is column data in 8.0 image format?
DATA_UPGRADED 30 VARCHAR2 (3 Byte) Y Has column data been upgraded to the latest type version format?
HIDDEN_COLUMN 31 VARCHAR2 (3 Byte) Y Is this a hidden column?
VIRTUAL_COLUMN 32 VARCHAR2 (3 Byte) Y Is this a virtual column?
SEGMENT_COLUMN_ID 33 NUMBER Y Sequence number of the column in the segment
INTERNAL_COLUMN_ID 34 NUMBER N Internal sequence number of the column
HISTOGRAM 35 VARCHAR2 (15 Byte) Y 　
QUALIFIED_COL_NAME 36 VARCHAR2 (4000 Byte) Y Qualified column name

'데이터베이스 > 오라클' 카테고리의 다른 글

오라클 DB 오브젝트 현황표 만들기  (0) 2008.01.22
DBA 는 얼마나 시간을 쓰나?(오라클 PT자료 중에서..)  (0) 2008.01.20
LOB 타입 DB link 카피 방법  (0) 2008.01.16
Using Oracle DDL Triggers  (0) 2008.01.16
오라클 DDL 모니터링 오라클 시스템 트리거 이용  (0) 2008.01.16
insert 문에 values 안에 select 문이 들어 간다?  (0) 2008.01.15
오라클 오브젝트 사용 현황  (0) 2008.01.10
import 시 분당 insert 갯수 보기  (0) 2007.12.28
NHN 2차 최종 면접 - 어리버리 1차 면접 합격(경력직)  (4) 2007.12.12
NHN면접 후기 - DB 엔지니어 경력  (5) 2007.12.05