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

less than 1 minute read

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 <code class="literal" style="margin: 0px; padding: 0px; border: 0px; font-family: 'Courier New';">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);


🔗original-link

Updated: