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.
iSQL> ALTER SESSION SET REPLICATION = DEFAULT; Alter success. iSQL> TRUNCATE TABLE t1; Truncate success.
iSQL> ALTER SYSTEM SET REPLICATION_DDL_ENABLE = 0; Alter success.
인덱스 추가 쿼리
CREATE INDEX IDX_F01
ON TBL_A (F01 ASC);