조회 : 1018
Supposing that the name of a replication target table is t1, DDL statements can be executed on the replication target table as follows.
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.