Tables

These tables are created, each in a different Oracle schema:

  • TESTDBSOURCE.ORDERS
  • TESTDBTARGET.ORDERS

Both tables are generated with this DDL:

CREATE
  TABLE "ORDERS"
  (
    "ID"           NUMBER NOT NULL ENABLE,
    "ORDER_NUMBER" VARCHAR2(20 BYTE) NOT NULL ENABLE,
    "ORDER_STATUS" VARCHAR2(20 BYTE),
    "DATE_TIME" DATE,
    "CUSTOMER" VARCHAR2(20 BYTE),
    CONSTRAINT "ORDERS_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2
    MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576
    MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST
    GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "USERS" ENABLE
  )
  SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  NOCOMPRESS LOGGING STORAGE
  (
    INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0
    FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT
    CELL_FLASH_CACHE DEFAULT
  )
  TABLESPACE "USERS" ;