Hi, I created issue https://issues.apache.org/jira/browse/IGNITE-1158 You can track it (add to watchers).
On Fri, Jul 24, 2015 at 10:53 PM, krishnangc < [email protected]> wrote: > Hi, > > I am using oracle sql developer 4.1.1.19 and the driver is ojdbc 6.1. The > script to create table is as follows > > CREATE TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" > ( "EXCEPTION_ID" VARCHAR2(100 CHAR), > "EXCEPTION_CREATED_DATE" DATE, > "EXCEPTION_PROCESSING_DATE" DATE, > "EXCEPTION_COMPLETION_DATE" DATE, > "EXCEPTION_PRIORITY" VARCHAR2(30 CHAR), > "EXCEPTION_SEVERITY" VARCHAR2(30 CHAR), > "GEOGRAPHY_ID" NUMBER(30,0), > "COUNTRY_ID" NUMBER, > "BRANCH_ID" NUMBER, > "L1L2STATUS" VARCHAR2(50 CHAR), > "SERVICE_LEVEL" VARCHAR2(100 CHAR), > "RECONCILIATION_TYPE" VARCHAR2(30 CHAR), > "UPDATED_BY" VARCHAR2(30 CHAR), > "UPDATED_DATE" TIMESTAMP (6), > "SESSION_ID" VARCHAR2(80 BYTE), > "RECORD_END_DATE" TIMESTAMP (6), > "RECORD_STATUS" VARCHAR2(10 CHAR), > "CREATED_DATE" TIMESTAMP (6), > "EXCEPTION_CATEGORY" VARCHAR2(32 BYTE), > "EXCEPTION_DESCRIPTION" VARCHAR2(180 BYTE), > "EXCEPTION_OID" NUMBER(30,0), > "EXCEPTION_STATUS" VARCHAR2(32 BYTE), > "EXCEPTION_TYPE_ID" NUMBER(30,0), > "FUNCTIONAL_AREA_ID" NUMBER(30,0), > "IPADDRESS" VARCHAR2(39 BYTE), > "PRODUCTLINE_ID" NUMBER(30,0), > "RECON_ID" VARCHAR2(32 BYTE), > "RECORD_VERSION" NUMBER(6,0), > "CREATED_BY" VARCHAR2(32 BYTE), > "LINK_ID" NUMBER(30,0), > "BUSINESS_CONTEXT_ID" VARCHAR2(32 CHAR), > "RECON_EXECUTION_ID" NUMBER(30,0), > "BUSINESS_PROCESS_ID" VARCHAR2(32 BYTE), > "MANUAL_ENTRY_FLAG" VARCHAR2(12 BYTE), > "PROCESSING_TYPE" VARCHAR2(32 BYTE), > "ASSET_CLASS_ID" VARCHAR2(32 BYTE), > "TRADE_DATE" DATE, > "PARENT_EXCEPTION_ID" VARCHAR2(100 BYTE), > "MERGED_EXCEPTION_ID" VARCHAR2(100 CHAR), > "GROUPED_EXCEPTION_ID" VARCHAR2(100 CHAR), > "EXCEPTION_GROUP_INDICATOR" VARCHAR2(10 CHAR), > "TOTAL_OUTSTANDING_AMOUNT" NUMBER(12,2), > "CLEARING_DATE" DATE, > "REASON_CODE" VARCHAR2(32 CHAR), > "COMMENTS" VARCHAR2(2000 CHAR), > "EXCEPTION_AUTHORIZATION_STATUS" VARCHAR2(32 CHAR), > "SUSPENSE_ENTRY_FLAG" VARCHAR2(10 CHAR) > ) SEGMENT CREATION IMMEDIATE > PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING > STORAGE(INITIAL 52428800 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" ; > -------------------------------------------------------- > -- DDL for Index EXCEPTION_MASTER_PK > -------------------------------------------------------- > > CREATE UNIQUE INDEX "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER_PK" ON > "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ("EXCEPTION_OID") > PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS > STORAGE(INITIAL 196608 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" ; > -------------------------------------------------------- > -- Constraints for Table EXCEPTION_MASTER > -------------------------------------------------------- > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ADD CONSTRAINT > "EXCEPTION_MASTER_PK" PRIMARY KEY ("EXCEPTION_OID") > USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS > STORAGE(INITIAL 196608 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; > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("EXCEPTION_ID" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("RECORD_STATUS" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("CREATED_DATE" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("EXCEPTION_OID" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("EXCEPTION_STATUS" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("IPADDRESS" > NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("RECORD_VERSION" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("CREATED_BY" > NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("LINK_ID" > NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("BUSINESS_CONTEXT_ID" NOT NULL ENABLE); > > ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY > ("RECON_EXECUTION_ID" NOT NULL ENABLE); > -------------------------------------------------------- > -- DDL for Trigger EXCEPTION_OID_TRIGGER > -------------------------------------------------------- > > CREATE OR REPLACE TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER" > before > INSERT ON "EXCEPTION_MASTER" FOR EACH row BEGIN IF inserting THEN > SELECT EXCEPTION_MASTER_SEQ.nextval INTO :NEW."EXCEPTION_OID" FROM dual; > END IF; > END; > > > > > > > / > ALTER TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER" DISABLE; > > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Duplicate-Field-when-creating-using-Apache-Ignite-Schema-Import-utility-tp709p711.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Alexey Kuznetsov GridGain Systems www.gridgain.com
