nihaobienao commented on issue #6560:
URL: https://github.com/apache/seatunnel/issues/6560#issuecomment-2566156901
> hi @cqy931 @jiexiadwo Can you provide the DDL of the table?
-- SMART_CITOS.SHIP_WORK_UNIT definition
CREATE TABLE "SHIP_WORK_UNIT"
( "WORK_UNIT_ID" VARCHAR2(36 CHAR) NOT NULL ENABLE,
"WORK_UNIT_NO" VARCHAR2(36 CHAR) NOT NULL ENABLE,
"SHIP_VISIT_NO" VARCHAR2(20 CHAR) NOT NULL ENABLE,
"IMP_EXP_MARK" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"LINE_RLS_NO" VARCHAR2(50 CHAR),
"UNIT_SPECIFIED" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"UNSPECIFIED_NO" VARCHAR2(20 CHAR) DEFAULT '0' NOT NULL ENABLE,
"UNIT_CLASS" VARCHAR2(10 CHAR) DEFAULT 'CN' NOT NULL ENABLE,
"UNIT_VISIT_NO" VARCHAR2(20 CHAR),
"UNIT_NO" VARCHAR2(40 CHAR),
"UNIT_ISO_CODE" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"UNIT_SIZE_CODE" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"UNIT_TYPE_CODE" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"UNIT_HEIGHT_CODE" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"EMPTY_FULL_MARK" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"UNIT_GRADE_CODE" VARCHAR2(20 CHAR),
"UNIT_OWNER_CODE" VARCHAR2(20 CHAR),
"UNIT_OPERATOR_CODE" VARCHAR2(20 CHAR),
"UNIT_AGENT_CODE" VARCHAR2(20 CHAR),
"UNIT_GROSS_WGT" NUMBER(14,5),
"UNIT_TARE_WGT" NUMBER(14,5),
"ON_SHIP_POSITION" VARCHAR2(20 CHAR),
"PLAN_ON_SHIP_POSITION" VARCHAR2(20 CHAR),
"STOW_REQUIRES" VARCHAR2(2000 CHAR),
"BILL_NO" VARCHAR2(50 CHAR),
"BOOKING_NO" VARCHAR2(50 CHAR),
"TRADE_TYPE" VARCHAR2(20 CHAR) NOT NULL ENABLE,
"ORIGINAL_LOC_CODE" VARCHAR2(20 CHAR),
"ORIGINAL_LOC_NAME" VARCHAR2(200 CHAR),
"ORIGINAL_POL_CODE" VARCHAR2(20 CHAR),
"POL_CODE" VARCHAR2(20 CHAR) NOT NULL ENABLE,
"POD_CODE" VARCHAR2(20 CHAR) NOT NULL ENABLE,
"SECOND_POD_CODE" VARCHAR2(20 CHAR),
"FINAL_POD_CODE" VARCHAR2(20 CHAR),
"ONCARRIAGE_LOC_CODE" VARCHAR2(20 CHAR),
"ONCARRIAGE_LOC_NAME" VARCHAR2(200 CHAR),
"UNIT_CATEGORY" VARCHAR2(10 CHAR) NOT NULL ENABLE,
"TRANSSHIPMENT_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"TRANS_TYPE_CODE" VARCHAR2(20 CHAR),
"SHIPPING_TYPE_CODE" VARCHAR2(20 CHAR),
"DECLARE_SHIP_CODE" VARCHAR2(20 CHAR),
"DECLARE_SHIP_NAME" VARCHAR2(200 CHAR),
"DECLARE_VOYAGE" VARCHAR2(20 CHAR),
"DECLARE_UNIT_OPER_CODE" VARCHAR2(20 CHAR),
"NEXT_SERVICE_CODE" VARCHAR2(20 CHAR),
"NEXT_VISIT_NO" VARCHAR2(20 CHAR),
"SEAL_NO1" VARCHAR2(80 CHAR),
"SEAL_NO2" VARCHAR2(80 CHAR),
"SEAL_NO3" VARCHAR2(80 CHAR),
"SEAL_NO4" VARCHAR2(80 CHAR),
"LCL_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"HAZARD_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"IMDG_CODE" VARCHAR2(5 CHAR),
"UNDG_NO" VARCHAR2(10 CHAR),
"HAZARDS" VARCHAR2(2000 CHAR),
"REEFER_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"TEMP_UNIT" VARCHAR2(10 CHAR),
"TEMP_SET" NUMBER(10,3),
"MIN_TEMP" NUMBER(10,3),
"MAX_TEMP" NUMBER(10,3),
"VENTILATION" NUMBER(10,3),
"VENTILATION_UNIT" VARCHAR2(10 CHAR),
"HUMIDITY" NUMBER(10,3),
"OOG_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"OOG_LEFT" NUMBER(10,2),
"OOG_RIGHT" NUMBER(10,2),
"OOG_FRONT" NUMBER(10,2),
"OOG_BACK" NUMBER(10,2),
"OOG_HIGH" NUMBER(10,2),
"UNIT_FEATURES" VARCHAR2(2000 CHAR),
"UNIT_CONDITIONS" VARCHAR2(2000 CHAR),
"BUNDLED_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"PARENT_UNIT_VISIT_NO" VARCHAR2(20 CHAR),
"CLEARANCE_TYPE_CODE" VARCHAR2(20 CHAR),
"DAMAGE_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"DAMAGES" VARCHAR2(2000 CHAR) DEFAULT '0',
"CARGO_CODE" VARCHAR2(20 CHAR),
"CARGO_NAME" VARCHAR2(2000 CHAR),
"CARGO_LABEL" VARCHAR2(2000 CHAR),
"PACKAGE_UNIT_CODE" VARCHAR2(20 CHAR),
"CARGO_QTY" NUMBER(10,0),
"CARGO_VOLUME" NUMBER(14,5),
"DELIVERY_CLAUSE_CODE" VARCHAR2(20 CHAR),
"OVERLANDED_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"WORK_TYPE" VARCHAR2(20 CHAR),
"WORK_FLOW_CODE" VARCHAR2(20 CHAR),
"WORK_METHOD_CODE" VARCHAR2(20 CHAR),
"DREDGE_MARK" VARCHAR2(1 CHAR) DEFAULT '0' NOT NULL ENABLE,
"DIFFICULT_TYPE_CODE" VARCHAR2(20 CHAR) DEFAULT '0' NOT NULL ENABLE,
"WORK_QUEUE_NO" VARCHAR2(40 CHAR),
"WORK_QUEUE_NAME" VARCHAR2(100 CHAR),
"WORK_MOVE_NO" VARCHAR2(40 CHAR),
"SEND_TIME" TIMESTAMP (6),
"SENDER_NO" VARCHAR2(20 CHAR),
"SHIP_CRANE_NO" VARCHAR2(20 CHAR),
"SHIP_CRANE_DRIVER_NO" VARCHAR2(20 CHAR),
"SHIP_CRANE_WORK_MODE" VARCHAR2(10 CHAR),
"QUAY_ARRIVE_TIME" TIMESTAMP (6),
"QUAY_WORK_TIME" TIMESTAMP (6) NOT NULL ENABLE,
"QUAY_DEPART_TIME" TIMESTAMP (6),
"QUAY_TALLYMAN_NO" VARCHAR2(20 CHAR),
"QUAY_TWIN_NO" VARCHAR2(36 CHAR),
"TRUCK_VISIT_NO" VARCHAR2(20 CHAR),
"TRUCK_NO" VARCHAR2(20 CHAR),
"TRUCK_DRIVER_NO" VARCHAR2(20 CHAR),
"ON_TRUCK_POSITION" VARCHAR2(10 CHAR),
"YARD_CRANE_NO" VARCHAR2(20 CHAR),
"YARD_CRANE_DRIVER_NO" VARCHAR2(20 CHAR),
"YARD_CRANE_WORK_MODE" VARCHAR2(10 CHAR),
"YARD_ARRIVE_TIME" TIMESTAMP (6),
"YARD_WORK_TIME" TIMESTAMP (6),
"YARD_DEPART_TIME" TIMESTAMP (6),
"YARD_TALLYMAN_NO" VARCHAR2(20 CHAR),
"YARD_TWIN_NO" VARCHAR2(36 CHAR),
"ON_YARD_POSITION" VARCHAR2(20 CHAR),
"PLAN_ON_YARD_POSITION" VARCHAR2(20 CHAR),
"ROLLBACK_MARK" VARCHAR2(1 CHAR) DEFAULT '0',
"NOTES" VARCHAR2(4000 CHAR),
"FACILITY_ID" VARCHAR2(36 CHAR) DEFAULT '0' NOT NULL ENABLE,
"CREATOR" VARCHAR2(36 CHAR) NOT NULL ENABLE,
"CREATED_ON" TIMESTAMP (6) NOT NULL ENABLE,
"CHANGER" VARCHAR2(36 CHAR) NOT NULL ENABLE,
"CHANGED_ON" TIMESTAMP (6) NOT NULL ENABLE,
"WORK_SHIFT_NO" VARCHAR2(20 CHAR),
"PROJECT_CARGO_CODE" VARCHAR2(20 CHAR),
"TRANSPORT_FEE_ID" VARCHAR2(1 CHAR) DEFAULT '0',
"LAST_PORT_CODE" VARCHAR2(20),
SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS,
SUPPLEMENTAL LOG GROUP "GGS_78100" ("WORK_UNIT_ID") ALWAYS
) 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 "CITOS_SPA" NO INMEMORY ;
CREATE UNIQUE INDEX "PK_SHIP_WORK_UNIT" ON "SHIP_WORK_UNIT"
("WORK_UNIT_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
ALTER TABLE "SHIP_WORK_UNIT" ADD CONSTRAINT "PK_SHIP_WORK_UNIT" PRIMARY KEY
("WORK_UNIT_ID")
USING INDEX "PK_SHIP_WORK_UNIT" ENABLE;
CREATE INDEX "IDX_SHIP_WORK_UNIT_02" ON "SHIP_WORK_UNIT" ("FACILITY_ID",
"SHIP_VISIT_NO", "IMP_EXP_MARK", "UNIT_VISIT_NO")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
CREATE INDEX "IDX_SHIP_WORK_UNIT" ON "SHIP_WORK_UNIT" ("SHIP_VISIT_NO",
"IMP_EXP_MARK", "UNIT_VISIT_NO", "FACILITY_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
CREATE INDEX "IDX_WORK_SHIFT" ON "SHIP_WORK_UNIT" ("WORK_SHIFT_NO",
"FACILITY_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
CREATE INDEX "INDEX_SAS_USE_SHIP" ON "SHIP_WORK_UNIT" ("QUAY_WORK_TIME",
"WORK_TYPE", "IMP_EXP_MARK", "UNIT_VISIT_NO", "FACILITY_ID", "ROLLBACK_MARK")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
CREATE UNIQUE INDEX "PK_SHIP_WORK_UNIT" ON "SHIP_WORK_UNIT"
("WORK_UNIT_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
CREATE UNIQUE INDEX "IDX_WORK_MOVE_NO" ON "SHIP_WORK_UNIT"
(NVL("WORK_MOVE_NO","WORK_UNIT_ID"))
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
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 "CITOS_SPA" ;
GRANT FLASHBACK ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT DEBUG ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT QUERY REWRITE ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT ON COMMIT REFRESH ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT READ ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT REFERENCES ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT UPDATE ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT SELECT ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT INSERT ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT INDEX ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT DELETE ON "SHIP_WORK_UNIT" TO "SMART_EDS";
GRANT ALTER ON "SHIP_WORK_UNIT" TO "SMART_EDS";
COMMENT ON TABLE SMART_CITOS.SHIP_WORK_UNIT IS '船舶装卸作业记录';
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
