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" ;