http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: Altibase

 회원가입

http://support.altibase.com/kr/manual [ NLS_DATE_FORMAT = altibase.properties:DEFAULT_DATE_FORMAT ]
최길호 [LIST]   2013-04-04 00:05:02, 조회 : 13,604

http://support.altibase.com/kr/manual

General Reference_KOR

1. 자료형 ................................................................................................................. 1
자료형의 개요 ....................................................................................................................................... 2
문자형 데이터 타입 ............................................................................................................................ 8
숫자형 데이터 타입 .......................................................................................................................... 13
날짜형 데이타 타입 .......................................................................................................................... 25
이진 데이터 타입 ............................................................................................................................... 37
LOB 데이타 타입 ............................................................................................................................... 42
공간 데이터 타입 ............................................................................................................................... 45

2. 알티베이스 프로퍼티 ..................................................................................... 47
환경 설정 방법 .................................................................................................................................. 48
데이터베이스 초기화 프로퍼티 ................................................................................................... 58
성능 관련 프로퍼티 .......................................................................................................................... 97
세션 관련 프로퍼티 ....................................................................................................................... 131
타임아웃 관련 프로퍼티 .............................................................................................................. 140
트랜잭션 관련 프로퍼티 .............................................................................................................. 151
백업 및 복구 관련 프로퍼티 ..................................................................................................... 154
이중화 프로퍼티 .............................................................................................................................. 160
메시지 로그 관련 프로퍼티 ....................................................................................................... 178
데이터베이스 링크 관련 프로퍼티 ......................................................................................... 199
DataPort 관련 프로퍼티 .............................................................................................................. 204
기타 프로퍼티 .................................................................................................................................. 206

3. 데이터 딕셔너리 ........................................................................................... 213
메타 테이블 ...................................................................................................................................... 214
SYS_COLUMNS_ ............................................................................................................................... 219
SYS_COMMENTS_ ........................................................................................................................... 223
SYS_CONSTRAINTS_ ....................................................................................................................... 224
SYS_CONSTRAINT_COLUMNS_ ................................................................................................. 227
SYS_DATABASE_ ............................................................................................................................... 229
SYS_DATABASE_LINKS_................................................................................................................. 230
SYS_DATA_PORTS_ ......................................................................................................................... 232
SYS_DIRECTORIES_......................................................................................................................... 234
SYS_ENCRYPTED_COLUMNS_ .................................................................................................... 235
SYS_GRANT_OBJECT_ .................................................................................................................... 236
SYS_GRANT_SYSTEM_ ................................................................................................................... 238
SYS_INDEX_COLUMNS_ ................................................................................................................ 239
SYS_INDEX_PARTITIONS_ ............................................................................................................ 241
SYS_INDICES_ ................................................................................................................................... 243
SYS_LOBS_ ......................................................................................................................................... 245
SYS_PART_INDICES_ ....................................................................................................................... 247
SYS_PART_KEY_COLUMNS_ ........................................................................................................ 249
SYS_PART_LOBS_ ............................................................................................................................. 251
SYS_PART_TABLES_ ......................................................................................................................... 253
SYS_PRIVILEGES_ .............................................................................................................................. 255
SYS_PROCEDURES_ ......................................................................................................................... 256
SYS_PROC_PARAS_ ......................................................................................................................... 259
SYS_PROC_PARSE_ .......................................................................................................................... 261
SYS_PROC_RELATED_ ..................................................................................................................... 262
SYS_REPLICATIONS_ ....................................................................................................................... 264
SYS_REPL_HOSTS_ ........................................................................................................................... 267
SYS_REPL_ITEMS_ ............................................................................................................................ 268
SYS_REPL_OFFLINE_DIR_ .............................................................................................................. 270
SYS_REPL_OLD_COLUMNS_ ........................................................................................................ 271
SYS_REPL_OLD_INDEX_COLUMNS_ ......................................................................................... 273
SYS_REPL_OLD_INDICES_ ............................................................................................................. 275
SYS_REPL_OLD_ITEMS_ ................................................................................................................. 277
SYS_REPL_RECOVERY_INFOS_.................................................................................................... 279
SYS_SECURITY_ ................................................................................................................................ 280
SYS_SYNONYMS_ ............................................................................................................................ 281
SYS_TABLES_ ..................................................................................................................................... 282
SYS_TABLE_PARTITIONS_ ............................................................................................................. 286
SYS_TBS_USERS_ .............................................................................................................................. 288
SYS_TRIGGERS_................................................................................................................................ 289
SYS_TRIGGER_DML_TABLES_ ...................................................................................................... 292
SYS_TRIGGER_STRINGS_ ............................................................................................................... 293
SYS_TRIGGER_UPDATE_COLUMNS_ ........................................................................................ 294
SYS_USERS_ ....................................................................................................................................... 295
SYS_VIEWS_ ....................................................................................................................................... 296
SYS_VIEW_PARSE_ ........................................................................................................................... 297
SYS_VIEW_RELATED_ ...................................................................................................................... 298
SYS_XA_HEURISTIC_TRANS_ ....................................................................................................... 300
성능 뷰 ................................................................................................................................................ 301
V$ALLCOLUMN ............................................................................................................................... 306
V$ARCHIVE ........................................................................................................................................ 307
V$BUFFPAGEINFO ........................................................................................................................... 308
V$BUFFPOOL_STAT ........................................................................................................................ 311
V$CATALOG ...................................................................................................................................... 317
V$DATABASE .................................................................................................................................... 318
V$DATAFILES .................................................................................................................................... 320
V$DATATYPE .................................................................................................................................... 323
V$DBA_2PC_PENDING .................................................................................................................. 327
V$DBLINK_REMOTE_STATEMENT_INFO................................................................................ 328
V$DBLINK_REMOTE_TRANSACTION_INFO .......................................................................... 329
V$DBLINK_TRANSACTION_INFO .............................................................................................. 330
V$DB_FREEPAGELISTS ................................................................................................................... 331
V$DB_PROTOCOL........................................................................................................................... 332
V$DIRECT_PATH_INSERT .............................................................................................................. 333
V$DISKTBL_INFO............................................................................................................................. 335
V$DISK_BTREE_HEADER ............................................................................................................... 337
V$EVENT_NAME .............................................................................................................................. 340
V$FILESTAT ........................................................................................................................................ 344
V$FLUSHER........................................................................................................................................ 346
V$FLUSHINFO .................................................................................................................................. 351
V$INDEX ............................................................................................................................................. 353
V$INSTANCE ..................................................................................................................................... 354
V$LATCH ............................................................................................................................................ 355
V$LFG ................................................................................................................................................... 356
V$LINKER_STATUS .......................................................................................................................... 360
V$LOCK ............................................................................................................................................... 361
V$LOCK_STATEMENT .................................................................................................................... 362
V$LOG ................................................................................................................................................. 363
V$LOCK_WAIT .................................................................................................................................. 365
V$MEMGC ......................................................................................................................................... 366
V$MEMSTAT ..................................................................................................................................... 368
V$MEMTBL_INFO ............................................................................................................................ 372
V$MEM_BTREE_HEADER .............................................................................................................. 374
V$MEM_BTREE_NODEPOOL ....................................................................................................... 376
V$MEM_RTREE_HEADER .............................................................................................................. 378
V$MEM_RTREE_NODEPOOL ....................................................................................................... 380
V$MEM_TABLESPACES .................................................................................................................. 382
V$MEM_TABLESPACE_CHECKPOINT_PATHS ...................................................................... 385
V$MEM_TABLESPACE_STATUS_DESC ..................................................................................... 386
V$MUTEX ........................................................................................................................................... 387
V$NLS_PARAMETERS ..................................................................................................................... 388
V$PLANTEXT ..................................................................................................................................... 390
V$PROCTEXT .................................................................................................................................... 391
V$PROPERTY .................................................................................................................................... 392
V$REPEXEC ........................................................................................................................................ 393
V$REPGAP .......................................................................................................................................... 394
V$REPGAP_PARALLEL .................................................................................................................... 396
V$REPLOGBUFFER ........................................................................................................................... 398
V$REPOFFLINE_STATUS ................................................................................................................ 399
V$REPRECEIVER ............................................................................................................................... 400
V$REPRECEIVER_COLUMN .......................................................................................................... 403
V$REPRECEIVER_PARALLEL ......................................................................................................... 404
V$REPRECEIVER_STATISTICS ...................................................................................................... 407
V$REPRECEIVER_TRANSTBL ........................................................................................................ 410
V$REPRECEIVER_TRANSTBL_PARALLEL ................................................................................. 411
V$REPRECOVERY ............................................................................................................................. 412
V$REPSENDER.................................................................................................................................. 414
V$REPSENDER_PARALLEL ............................................................................................................ 417
V$REPSENDER_STATISTICS ......................................................................................................... 419
V$REPSENDER_TRANSTBL ........................................................................................................... 421
V$REPSENDER_TRANSTBL_PARALLEL .................................................................................... 422
V$REPSYNC ....................................................................................................................................... 423
V$SEGMENT ...................................................................................................................................... 424
V$SEQ .................................................................................................................................................. 425
V$SERVICE_THREAD ....................................................................................................................... 427
V$SESSION ........................................................................................................................................ 430
V$SESSION_EVENT ......................................................................................................................... 437
V$SESSION_WAIT ............................................................................................................................ 439
V$SESSION_WAIT_CLASS ............................................................................................................. 441
V$SESSIONMGR ............................................................................................................................... 443
V$SESSTAT ........................................................................................................................................ 445
V$SQLTEXT ........................................................................................................................................ 446
V$SQL_PLAN_CACHE ..................................................................................................................... 447
V$SQL_PLAN_CACHE_PCO .......................................................................................................... 449
V$SQL_PLAN_CACHE_SQLTEXT ................................................................................................. 451
V$STABLE_MEM_DATAFILES ....................................................................................................... 453
V$STATEMENT ................................................................................................................................. 454
V$STATNAME ................................................................................................................................... 461
V$SYSSTAT ........................................................................................................................................ 468
V$SYSTEM_CONFLICT_PAGE ...................................................................................................... 469
V$SYSTEM_EVENT ........................................................................................................................... 470
V$SYSTEM_WAIT_CLASS .............................................................................................................. 472
V$TABLE.............................................................................................................................................. 474
V$TABLESPACES .............................................................................................................................. 475
V$TRACELOG .................................................................................................................................... 478
V$TRANSACTION ............................................................................................................................ 481
V$TRANSACTION_MGR ................................................................................................................ 486
V$TSSEGS ........................................................................................................................................... 487
V$TXSEGS .......................................................................................................................................... 489
V$UDSEGS ......................................................................................................................................... 491
V$UNDO_BUFF_STAT ..................................................................................................................... 493
V$USAGE ............................................................................................................................................ 494
V$VERSION ....................................................................................................................................... 496
V$VOL_TABLESPACES .................................................................................................................... 497
V$WAIT_CLASS_NAME .................................................................................................................. 498
V$XID ................................................................................................................................................... 500

4. 샘플 스키마................................................................................................... 503
예제 테이블 정보 ............................................................................................................................ 504
E-R 다이어그램과 샘플 데이타 ................................................................................................ 507

//// memo

DEFAULT_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' (altibase.properties) [ 바로 적용 되지 않고 DB RESTART ]
alter session set DEFAULT_DATE_FORMAT='yyyy/mm/dd hh24:mi:ss';

$ export ALTIBASE_NLS_USE=UTF8
NLS_USE=KO16KSC5601 (altibase.properties)

exec gather_database_stats();

4. 샘플 스키마
$ALTIBASE_HOME/sample/APRE/schema/schema.sql
기 능: 고객과 주문 관리
테이블: employees, departments, customers, orders, goods

추가 2013/07/28
ps -ef | grep altibase
altibase -version
more $ALTIBASE_HOME/conf/altibase.properties
v$datafiles
v$tablespaces

NLS 관련
grep NLS $ALTIBASE_HOME/conf/altibase.properties
export ALTIBASE_NLS_USE=UTF8
select SESSION_ID,NLS_USE,NLS_CHARACTERSET from V$NLS_PARAMETERS;
  NLS_USE: SESSION NLS
  NLS_CHARACTERSET: DB NLS
3.235.78.122


  LIST

제목 작성자 작성일 조회
Admin  dbf 위치 확인 / 삭제 / create database [$ server create MS949 UTF8 ] / 서비스 시작    최길호 2020/10/08 262
Troubleshoot  [FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]    최길호 2020/10/07 343
Admin  주소 iloader in [ csv data import ]    최길호 2020/10/07 271
Admin  altibase replication test    최길호 2016/11/17 1847
Backup & Recovery  hot backup script [ alter database backup database to '/backup/'; ]    최길호 2016/10/02 1181
Admin  -- 모든 테이블    최길호 2016/10/02 1092
Admin  [ERR-110A4 : Backup in progress. Please wait until the current backup is completed.]    최길호 2016/10/02 746
Admin  Sybase IQ 15.2 evaluation software    최길호 2013/08/21 2875
Admin  alter database rename datafile    최길호 2013/07/27 4150
Backup & Recovery  aexport lv:9   최길호 2013/07/22 1346
Admin  alter tablespace ts_disk1 alter datafile '/altibase/6.1/dbs/tbs_disk1_200.dbf' autoextend on next 200m maxsize unlimited;    최길호 2013/04/13 2784
Troubleshoot  [FAILURE] The data file '/altibase/6.1/dbs/SYS_TBS_MEM_DIC-0-0' has an invalid header. lv:9   최길호 2013/04/11 1383
Troubleshoot  oracle to altibase data type 호환     최길호 2013/04/05 2892
Admin  getdata.sql [ 오라클, 알티베이스 마이그레이션 내용 ] lv:9   최길호 2013/04/05 1299
Admin  http://support.altibase.com/kr/manual [ NLS_DATE_FORMAT = altibase.properties:DEFAULT_DATE_FORMAT ]    최길호 2013/04/04 13604
Admin  altibase 교육 자료 lv:4   최길호 2013/04/03 1496

    목록보기 1
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호