Data Replication
- Data Replication 9.7.0
- All Products
CREATE TABLE [dbo].[TABLE_DEMO]( [IDKEY] [int] NOT NULL PRIMARY KEY, [DATA] [varchar](20) NULL );
CREATE TABLE "ORA_TARGET"."TABLE_DEMO" ( "IDKEY" NUMBER (10, 0) NOT NULL, "DATA" VARCHAR2(20) NULL, PRIMARY KEY ("IDKEY") )
ALTER TABLE [dbo].[TABLE_DEMO] ADD [INTDATA] INTEGER;
ALTER TABLE "ORA_TARGET"."TABLE_DEMO_LOG" ADD ("INTDATA_OLD" NUMBER(10) NULL , "INTDATA_NEW" NUMBER(10) NULL )
CREATE TABLE ORA_SOURCE.TABLE_DEMO ( IDKEY NUMBER(22,0) NOT NULL PRIMARY KEY, DATA VARCHAR2(20) );
CREATE TABLE "NZ_TARGET"."TABLE_DEMO" ( "IDKEY" NUMERIC(22,0) NOT NULL, "DATA" VARCHAR(20) NULL ) CREATE TABLE "NZ_TARGET"."TABLE_DEMO_LOG" ( "OP_TIME" TIMESTAMP , "OP_CODE" CHAR(1) NOT NULL, "OP_CMT_SCN" NUMERIC(20) NOT NULL, "OP_CMT_TIME" TIMESTAMP , "OP_XID" NUMERIC(22) , "OP_NUM_IN_TX" BIGINT NOT NULL, "OP_KEY_LEVEL" INTEGER , "OP_ROOT_KEY_ROWID" BIGINT , "IDKEY_OLD" NUMERIC(22,0) NOT NULL, "IDKEY_NEW" NUMERIC(22,0) NOT NULL, "DATA_OLD" VARCHAR(20) NULL, "DATA_NEW" VARCHAR(20) NULL )