The Applier task can apply the following DDL operations to Netezza targets:
ALTER TABLE
table_name
ADD
column_name
datatype
[NULL|NOT NULL]
ALTER TABLE
table_name
ADD CONSTRAINT
constraint_name
UNIQUE (
column_name
)
ALTER TABLE
table_name
DROP COLUMN
column_name
CASCADE
ALTER TABLE
table_name
DROP CONSTRAINT
constraint_name
CASCADE
ALTER TABLE
table_name
MODIFY COLUMN
column_name
datatype
CREATE TABLE
table_name
(
column_name
datatype
[NULL|NOT NULL] [PRIMARY KEY (
column_name
)]) DISTRIBUTE ON {(
column_name
)|RANDOM}
DROP TABLE
table_name
Data Replication does not support replication of DDL operations for source tables and columns that have lowercase names. The Applier ends abnormally when replicating subsequent DML changes to the corresponding tables and columns on a Netezza target.
Data Replication does not replicate indexes that were created on a source database to Netezza targets. Netezza does not use indexes.
Data Replication does not replicate ALTER COLUMN operations that add NULL and NOT NULL constraints for a source column to Netezza targets. Netezza does not support DDL operations of this type.
Data Replication does not replicate ALTER COLUMN operations that modify a column datatype to Netezza targets. Netezza does not support DDL operations of this type.
Data Replication does not replicate ALTER COLUMN operations that modify the length of columns that have a datatype other than CHAR, NCHAR, NVARCHAR, and VARCHAR to Netezza targets. Netezza does not support DDL operations of this type.
Data Replication does not replicate ADD COLUMN operations that add a column that has a NOT NULL constraint but no default value from Oracle sources to Netezza targets. Netezza does not support this type of DDL operations.
Data Replication replicates TRUNCATE TABLE operations from sources to Netezza targets as DELETE FROM operations.
To replicate CREATE TABLE operation to Netezza targets, Data Replication creates a table on the target and distributes data on the columns that are mapped to the primary key columns on the source. If the source table does not have a primary key definition, Data Replication uses the DISTRIBUTE ON RANDOM clause.