 	"DRL_ID" varchar(45), 
 	"DRUG_CODE" varchar(20), 
 	"DELETED" DATE, 
-	"PROD_GENERIC_NAME" CLOB, 
-	"PROD_GENERIC_NAME_J" CLOB, 
+	"PROD_GENERIC_NAME" varchar(3900), 
+	"PROD_GENERIC_NAME_J" varchar(3900), 
 	"IND_LLT_CODE" varchar(50), 
 	"IND_LLT" varchar(250), 
 	"IND_HLT_CODE" varchar(50), 

	"DEV_INTL_BIRTH_DATE" DATE, 
	"COMMENTS_J" varchar(1000 CHAR)
   ) 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 "AM_MART_DATA_01" 
 LOB ("PROD_GENERIC_NAME") STORE AS BASICFILE "RLP_PROD_GENERIC_NAME_CLOB"(
  TABLESPACE "AM_MART_LOB_01" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION 
  NOCACHE 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)) 
 LOB ("PROD_GENERIC_NAME_J") STORE AS BASICFILE "RLP_PROD_GEN_NAME_J_CLOB"(
  TABLESPACE "AM_MART_LOB_01" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION 
  NOCACHE 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)) ;
--------------------------------------------------------
--  DDL for Index PK_RM_LM_PRODUCT
--------------------------------------------------------

  CREATE UNIQUE INDEX "MART_USER"."PK_RM_LM_PRODUCT" ON "MART_USER"."RM_LM_PRODUCT" ("ENTERPRISE_ID", "PRODUCT_ID") 
  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 "AM_MART_INDEX_01" ;
--------------------------------------------------------
--  Constraints for Table RM_LM_PRODUCT
--------------------------------------------------------

  ALTER TABLE "MART_USER"."RM_LM_PRODUCT" ADD CONSTRAINT "PK_RM_LM_PRODUCT" PRIMARY KEY ("ENTERPRISE_ID", "PRODUCT_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 "AM_MART_INDEX_01"  ENABLE;
 
  ALTER TABLE "MART_USER"."RM_LM_PRODUCT" MODIFY ("ENTERPRISE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  File created - Saturday-April-04-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table RM_LM_PRODUCT_FAMILY
--------------------------------------------------------

  create table "RM_LM_PRODUCT_FAMILY" 
   (	"ENTERPRISE_ID" NUMBER , 

	"EFFECTIVE_START_DATE" DATE, 
	"EFFECTIVE_END_DATE" DATE
   ) SEGMENT CREATION IMMEDIATE 

  create table "RM_CASE_PRODUCT" 
   (	"ENTERPRISE_ID" NUMBER , 
