알티베이스 리플리케이션 테이블 DDL변경법

http://technet.altibase.com/?page_id=13025

5.4. Example

Supposing that the name of a replication target table is t1, DDL statements can be executed on the replication target table as follows.

  • Execution of the TRUNCATE TABLEstatement.(SYS User)
     iSQL> ALTER SYSTEM SET REPLICATION_DDL_ENABLE = 1; Alter success.

    (Table Owner)

     iSQL> ALTER SESSION SET REPLICATION = DEFAULT; Alter success.  iSQL> TRUNCATE TABLE t1; Truncate success.

    (SYS User)

     iSQL> ALTER SYSTEM SET REPLICATION_DDL_ENABLE = 0; Alter success.

-------=-------
인덱스 추가 쿼리
CREATE INDEX IDX_F01
ON TBL_A (F01 ASC);

댓글
  • No Nickname
    No Comment
  • 권한이 없습니다.
    {{m_row.m_nick}}
    -
목록형 📷 갤러리형
제목
[기본형] HTML (with 부트스트랩5.3 , jquery 3.7, vue.js)
유용한 리눅스(LINUX) 명령어
[공지] 기술 게시판
3.31
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.10
4.11
4.12
4.13
4.14
4.15
4.16
4.17
4.18
4.19
4.20
4.21
4.22
4.23
4.24
4.25
4.26
4.27
4.28
4.29
4.30
5.1
5.2
5.3
5.4