Bug on Oracle 11g
CREATE TABLE "PROJECT"."TB_MAN_ME_EQUIPMENT" ( "ME_COMPANY" VARCHAR2(2) NOT NULL ENABLE, "ME_EQUIPMENT_CODE" VARCHAR2(8) NOT NULL ENABLE, "ME_EQUIPMENT_NAME" VARCHAR2(100) NOT NULL ENABLE, "ME_MACHINE_CODE" VARCHAR2(5) NOT NULL ENABLE, "ME_SETOR_CODE" VARCHAR2(2) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "MANTAB" ;
CREATE UNIQUE INDEX "PROJECT"."PK_MAN_ME" ON "PROJECT"."TB_MAN_ME_EQUIPMENT" ("ME_COMPANY", "ME_EQUIPMENT_CODE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "MANNDX" ;
ALTER TABLE "PROJECT"."TB_MAN_ME_EQUIPMENT" MODIFY ("ME_COMPANY" NOT NULL ENABLE);
ALTER TABLE "PROJECT"."TB_MAN_ME_EQUIPMENT" MODIFY ("ME_EQUIPMENT_CODE" NOT NULL ENABLE);
ALTER TABLE "PROJECT"."TB_MAN_ME_EQUIPMENT" MODIFY ("ME_EQUIPMENT_NAME" NOT NULL ENABLE);
ALTER TABLE "PROJECT"."TB_MAN_ME_EQUIPMENT" MODIFY ("ME_MACHINE_CODE" NOT NULL ENABLE);
GRANT INSERT, SELECT, UPDATE ON "PROJECT"."TB_MAN_ME_EQUIPMENT" TO PUBLIC;
GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON "PROJECT"."TB_MAN_ME_EQUIPMENT" TO "INTERNAL_USER";
GRANT INSERT, SELECT, UPDATE ON "PROJECT"."TB_MAN_ME_EQUIPMENT" TO "PROJECTFRB";