알티베이스 리플리케이션 테이블 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
<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);