--------------------------------------------------------
--  File created - Wednesday-September-30-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table MT_PROD_OBJECTS
--------------------------------------------------------

  CREATE TABLE "STORETW"."MT_PROD_OBJECTS" 
   (	"ONAME" VARCHAR2(256 BYTE), 
	"OTYPE" VARCHAR2(256 BYTE), 
	"OWNER" VARCHAR2(256 BYTE), 
	"PRE_ETL" VARCHAR2(15 BYTE), 
	"PRE_PROD" VARCHAR2(15 BYTE), 
	"COMMENT_DESC" VARCHAR2(4000 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 COMPRESS FOR OLTP NOLOGGING
  STORAGE(INITIAL 163840 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "STORETDATA_STORMODP" ;

   COMMENT ON COLUMN "STORETW"."MT_PROD_OBJECTS"."ONAME" IS 'Object Name';
   COMMENT ON COLUMN "STORETW"."MT_PROD_OBJECTS"."OTYPE" IS 'Object Type';
   COMMENT ON COLUMN "STORETW"."MT_PROD_OBJECTS"."OWNER" IS 'Owner';
   COMMENT ON COLUMN "STORETW"."MT_PROD_OBJECTS"."PRE_ETL" IS 'REQUIRED TO BE PRESENT BEFORE WQX ETL.';
   COMMENT ON COLUMN "STORETW"."MT_PROD_OBJECTS"."PRE_PROD" IS 'REQUIRED TO PRESENT BEFORE MOVING TO PRODUCTION';
   COMMENT ON COLUMN "STORETW"."MT_PROD_OBJECTS"."COMMENT_DESC" IS 'Comment Description';
REM INSERTING into STORETW.MT_PROD_OBJECTS
SET DEFINE OFF;
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_STATION_ALIAS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATN_ALIAS_ISD_FK_STATION','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATN_ALIAS_ISD_FK_REF_SCHEME','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_UNIT_CONVERSION','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_WS_SERVICE','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATION_PROJECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_VIEW','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_WEB_METHOD_INPUT_PARAM','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_ANALYTICAL_PROC','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_CITATION','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_COOP_ADDRESS','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_COOP_EADDRESS','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_LAB','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_LAB_EADDR','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_LAB_SPP','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_ORG_ADDRESS','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_PROGRAM','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_SAMPLE_GEAR','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_SAMPLE_PRESRV','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_SAMPLE_PROC','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_DI_CHARACTERISTIC','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_ACTIVITY_MEDIUM','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_UNIT_CONVERSION','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MY_SEQ_GENERATOR','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('GETSTATNTYPESORTORDERVALUE','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DELETEFROMSTORETW','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_COMPUTE_STD_LAT_LONG','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_STATION_CHAR','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_INDEXTYPE','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_METRICTYPE','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_QA_AGENCY','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_UNIQUE_RESULT_PROJECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_ACTIVITY_METRIC','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_BIO_HABITAT_INDEX','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_UNIT_CONV','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_ANALYTICAL_PROC','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ANALY_PROC','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IANLFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_CITATION','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICIT_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICITFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_COOP','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICOORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICOFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CO_OP_ADDR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IACOORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IACOOP','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CO_ORG_EADDR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IECOORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IECOOP','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_LAB','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LAB_ORG_NO','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ILABFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_LAB_ADDRESS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IALBORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IALAB','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_LAB_EADDRESS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IELBORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IELAB','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_LAB_SAMPLE_PREP_PROCEDURE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ILSPPORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ILSPPFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ORG_ADDR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IAORG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ORG_EADDR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IEORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IEORG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_PROGRAM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IPRGORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_SAMPLE_GEAR','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_SAMPLE_GEAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('APP_COLUMN_NAME','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_APP_COL','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('BIOLOGICAL_RESULT_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBP_FK_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBP_FK_PROJECT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBP_FK_PROJECT_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CHARACTERISTIC_CHARTYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CPK_CHAR_CHARTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('UICCT01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_CCTYPE_FK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_CCTYPE_FK_CHARTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_ACTIVITY_INTENT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ACTIVITY_INTENT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_ACTIVITY_MATRIX','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_DI_ACTIVITY_MATRIX','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_ACTIVITY_MEDIUM','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ACT_MEDIUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IACT_MEDIUM01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_BIOPART','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_BIOPART','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_CHARACTERISTIC','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICHAR01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_COMMUNITY_SAMPLED','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_COMMUNITY_SAMPLED','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_DATE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_DATE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IDATE_FULL_DATE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_DB_CAT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DB_CAT02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_GEO_COUNTY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_GEO_COUNTY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DB_COUNTY01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DB_COUNTY02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_GEO_STATE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_GEO_STATE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('GEO_STATE02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('GEO_STATE03','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('GEO_STATE04','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_GROUP_TYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_GROUP_TYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_ORG','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ORG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IORGTEMP1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_PROJECT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IPR_ISN_ORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_DI_PROJECT_SOURCEUID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_STATN_TYPES','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_STATN_TYPES','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISTATN_TYPE01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISTATN_TYPE02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_SUBJECT_TAXON','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_SUBJECT_TAXON','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_DATA_REQUESTS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_DW_DATA_REQUESTS','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_DW_DR_DATETIME','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_BIOLOGICAL_RESULT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_BIOLOGICAL_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_ACT_IS_NUM_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_LBRMK_01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_DATE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_ACTIVITY_ISN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_GEO2','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_ACTIVITY_METRIC','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_PROJECT_STATION_CHAR_TEMP','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_PROJECT_STATION_CHAR','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MT_OBJECT_DDL_WQX_ETL','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_DATA','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_HUC_CHAR_SUMMARY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_WS_HUC_CHAR_SUMMARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_HUC_ORG_CHAR_SUMMARY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_WS_HUC_ORG_CHAR_SUMMARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_SUMMARY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CPK_WS_SERVICE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_SERVICE_NAME','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CPK_WS_WEB_METHOD','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_WEB_METHOD_FK_SERVICE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CPK_WS_WEB_METHOD_INPUT_PARAM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_WS_WEB_METHOD_INPUT_PARAM','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_IP_PARAM_FK_WEB_METHOD','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_BITMAP_FA_STATION_VISITED','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_FN_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_FN_STATION_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_ORG_ACTIVITY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_ORG_ACTIVITY_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_INDEXTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_METRICTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_QA_AGENCY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_STG_ACTIVITY_PROJECT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_FA_HABITAT_RESULT_SOURCEUID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFHR_LT_CHAR_NAME_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFHR_LT_OID_ACTIVITY_ID_FKCHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ACTMET','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_BIO_HABITAT_IDX','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_ACTIVITY_GROUP','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ACTIVITYGROUP','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_ACTIVITYGROUP','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_PROJECT_STATION_CHAR','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_REGULAR_RESULT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_BIOLOGICAL_RESULT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_STATN_TYPES','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_GEN_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_STATION','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_HUC','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_DATE_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_CHAR_DATE_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_STATE_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_HUC_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STG_ACTIVITY_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_WS_SERVICE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_WEB_METHOD_INPUT_PARAM','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ACTIVITY_METRIC_INDEX','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_BIO_HABITAT_INDEX','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_METRICTYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_QA_AGENCY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_DW_DATA_REQUEST_ID','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_HUC_ORG_CHAR_SUMMARY','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_HUC_ORG_SUMMARY','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_SUMMARY','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_ORG','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_DB_CAT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DBXML_WME','PACKAGE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DBXML_WME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULT_STATION_WME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BOTTOM_OF_PAGE','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BOTTOM_OF_PAGE','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_CHAR_SELECT_WME','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_GEO','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_GEO','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROJ_POPUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROJECT_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROJECT_SELECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_MEDIUM_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_MEDIUM_SELECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_INTENT_COMMUNITY_SELECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HUC_POPUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HUC_POPUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HOME','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULT_STATION_WME','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULT_STATION_WME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATIONCRITERIA','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_HUB_CUSTOM','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_HUB_CUSTOM','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_DOWNLOAD_ZIP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_DOWNLOAD_ZIP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_DOWNLOAD_CUSTOM','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_COUNT_TEST','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_COUNT_TEST','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_COUNT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_COUNT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_STATION_WME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_STATION','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_STATION','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_PROJECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_PROJECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_WME_PKG','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_STATION_WME_VW','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_STATION_WME_VW','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_STATION_NV_VW','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATION_VIEW','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATION_VIEW','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_TOP_OF_PAGE','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_SELECT_WME','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_SELECT_WME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_SELECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_POPUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_POPUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_HUB_CUSTOM','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_HUB_CUSTOM','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_DOWNLOAD_ZIP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_DOWNLOAD_ZIP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_DOWNLOAD_CUSTOM','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_DOWNLOAD_CUSTOM','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_COUNT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATION_COUNT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATIONCRITERIA_STN','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATIONCRITERIA_STN','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULTCRITERIA_STATION','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULTCRITERIA_STATION','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULTCRITERIA_PROJECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULTCRITERIA_PROJECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULTCRITERIA_GEO','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HAB_RESULTCRITERIA_GEO','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_GEO_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_GEO_SELECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_EXTREF_POPUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_EXTREF_POPUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_DISPLAY_CALENDAR','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_DISPLAY_CALENDAR','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_DATE_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_DATE_SELECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_COUNTY_POPUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_COUNTY_POPUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_CHAR_ALIAS_POPUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_CHAR_ALIAS_POPUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BLOB_DOWNLOAD','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BLOB_DOWNLOAD','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULTCRITERIA_STATION','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULTCRITERIA_STATION','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DWG_RESULTCRITERIA','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULTCRITERIA_GEO','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULTCRITERIA_GEO','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULTCRITERIA_PROJECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULTCRITERIA_PROJECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BATCH_DOWNLOAD_PICKUP','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BATCH_DOWNLOAD_PICKUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('TRANSLATE_WME','FUNCTION','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('BlobHandler','JAVA CLASS','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('BlobHandler','JAVA SOURCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ExecOS','JAVA CLASS','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CaptureStream','JAVA CLASS','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ExecOS','JAVA SOURCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_GLOB_VAR','PACKAGE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_REPORT_PENDING_REQUESTS','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_CHAR_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('EXECMD','FUNCTION','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROCESS_DATA_REQUEST','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROCESS_BATCH_REQUESTS','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_MONTHLY_STATS','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('EXPORTBLOB','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RECORD_DATA_REQUEST','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROCESS_PENDINGBATCH_IMM','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_CNT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROCESS_DATA_REQUEST_LIST','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_MAIL_PKG','PACKAGE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ETL_GLOB_VAR','PACKAGE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_MAIL_PKG','PACKAGE BODY','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DBXML_WME','PACKAGE BODY','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_WME_PKG','PACKAGE BODY','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_VIEW_VIEW','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_VIEW_PROD','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_SEQUENCE_SYNCH','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_SS_CHARTYPE_STATION_ORG','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_HO_HUC','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_PROJ_STATN_CHAR','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_HO_HUC_ORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_HOC_HUC','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBWSPSC_FK_PROJT','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_ORGID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_ORGID_STNID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_FK_PROJ','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_ORG_ACTIVITY_FN_ORG_ACT','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_ORG_ACT_PROJ_ORG_ACT_DATE','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_ORG_ACTIVITY','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_ORG_ACT_PROJ','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_STATION','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PROJECT_STATION_CHAR','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PROJECT_CHAR','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CHARACTERISTIC_CHARTYPE','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STORET_RESULT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_ORG_ACTIVITY_PROJECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_CHARACTERISTIC','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MT_WH_CONFIG','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_CREATE_INDEXES_AFTER_WQXETL','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_HUC_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFBR_LT_STN_ID_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFBR_LT_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFBR_LT_OID_ACTIVITY_ID_FKCHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_FK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_BR_CHAR_NAME','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFHR_LT_STN_ID_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFHR_LT_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_FN_LT_STATION_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_LT_OID_LT_SID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ILU_CHARTYPE_PK_ISN_LTCHARTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_PK_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_PK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_STN_ACT_PT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_ACT_IS_NUM_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_FK_ACT_MEDIUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFAR_ACTIVITY_ID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_GEO1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_ACTBLOB','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_DATE_LAT_LONG_MEDIUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_CHAR_DATE_LAT_LONG_MEDIUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_STATE_DATE_CHAR_MEDIUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_COUNTY_DATE_CHAR_MEDIUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_DATE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_ACITIVTY_ISN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_GEO2','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_GEN_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_STATION','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICS_FK_CHAR_FK_FA_STATN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_STATN_TYPES','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICS_FK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICS_SEARCH_NAME','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICS_CHAR_TYPE_CODE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_STATE','MATERIALIZED VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_SNAP$_MV_REGULAR_RESULT_1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_CHAR','MATERIALIZED VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_SNAP$_MV_REGULAR_RESULT_2','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_CHAR_STATE','MATERIALIZED VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_SNAP$_MV_REGULAR_RESULT_3','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_COUNTY','MATERIALIZED VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_SNAP$_MV_REGULAR_RESULT_4','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_CHAR_COUNTY','MATERIALIZED VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_STN_LOC_IX','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MDRS_20804$','SEQUENCE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROJECT_BLOB_MD','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICHAR02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_ORG1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_GEO1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISGFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_SAMPLE_PRESRV','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_SAMPLE_PRESRV','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISPPORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISPPFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_SAMPLE_PROC','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_SAMPLE_PROC','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISAMPROC_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISPFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MT_CHAR_CHARTYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_MT_CHAR_CHARTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('REGULAR_RESULT_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRP_FK_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRP_FK_PROJECT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRP_FK_PROJECT_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATION_CHAR','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATION_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISP_FK_FA_STATN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISP_FK_PROJECT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISP_ORGANIZATION_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISP_STATION_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MT_ATTRIBUTE_MAP','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_MT_ATTR_MAP','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_MT_ATTR_02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MT_WH_CONFIG','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_MT_WH_CONFIG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_GEN','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_HUC_ORG_SUMMARY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_WS_HUC_ORG_SUMMARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STATION_VIEW','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_GLOB_VAR','PACKAGE BODY','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_DROP_GEOM_DOMAIN_INDEX','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_CREATE_INDEX_ON_FA_STN_GEOM','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_UPDATE_TRIBAL_IN_RESULTS','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_ACTIVITY_INTENT','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_ACTIVITY_MATRIX','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_BIOFDACT_TEMP2','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_BIOPART','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_COMMUNITY_SAMPLED','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_DB_CAT','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_DI_DATE','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_DI_PROJECT','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_ESTRY_PRIMARY','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_ESTRY_SECONDARY','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_BIOLOGICAL_RESULT','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_HABITAT_RESULT','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_REGULAR_RESULT','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_STATION','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FDACT_TEMP2','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_GEO_COUNTRY','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_GEO_COUNTY','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_GEO_STATE','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_GROUP_TYPE','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_HBFDACT_TEMP2','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_CHAR_ALIAS_TYPE','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_EXTERNAL_REF_SCHEME','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_LU_STATION_ALIAS','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MAD_HDATUM','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MAD_HMETHOD','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MAD_VDATUM','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MAD_VMETHOD','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_ORG','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_STATN_TYPES','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_SUBJECT_TAXON','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_STATION_DATA','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_HUC_CHAR_SUMMARY','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_HUC_ORG_SUMMARY','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_ORG_CHAR_SUMMARY','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_STATION_SUMMARY','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DELETEDATAFROMSTORETWTABLE2','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_POST_PROCESSING_FOR_WQX_ETL','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_PRE_PROCESSING_FOR_WQX_ETL','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_FETCH_CONFIG_VALUE','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_STATION_CHAR_NEW','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_TABLES_NEW','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_RUN_WATERSHED_TAB_REFRESH','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DELETEDATAFROMSTORETWTABLE','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DELETEDATAFROMTABLE','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WHEREAMI','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_STORET_RESULT','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ACTIVITY_GROUP_DETAIL','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_HABITAT_RESULT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_COUNTY_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_WEB_METHOD','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_INDEXTYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_HUC_CHAR_SUMMARY','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_CHARTYPE','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_BIO_RESULT_STATION_WME','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_CHAR_SELECT_WME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_PROJ_POPUP','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_INTENT_COMMUNITY_SELECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_HOME','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_STATIONCRITERIA','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_DOWNLOAD_CUSTOM','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULTCRITERIA_STATION_WME','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_WME_PKG','PACKAGE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STORET_STATION_NV_VW','VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_TOP_OF_PAGE','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_ORG_ACTIVITY','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_DROP_INDEXES_B4_WQXETL','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFBR_LT_CHAR_NAME_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHR_FK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_OID_SID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_ORG_ACT_FN_STN_ID2','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFAR_LT_CHAR_NAME_OID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_ORG1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_BLOB','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_MEDIUM_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFA_RESULT_LBRMK_01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IRE_GEN_HUC','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICS_FK_FA_STATN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_SNAP$_MV_REGULAR_RESULT_','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_ALL','MATERIALIZED VIEW','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MDRT_20804$','TABLE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DW_RESULT_METADATA','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MAD_HMETHOD02','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_MAD_VMETHOD','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_STATION_ALIAS','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DI_PROJECT','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('WS_WEB_METHOD','SYNONYM','STORETWEB','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_COOP','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_LAB_ADDR','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MD_ORG_EADDRESS','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_FA_BLOB','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('INSERTINTOACTIVITYPROJECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_REFRESH_WS_TABLES','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SP_INSERTINTOACTIVITYPROJECT','PROCEDURE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IANLORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CITATION','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CO_ORG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_COOP_ADDRESS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_COOP_EADDRESS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_LAB','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LAB_ORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_LAB_ADDR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_LAB_EADDR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_LAB_SPP','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_ORG_ADDRESS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_ORG_EADDRESS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MD_PROGRAM','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IPROFK','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISGORGID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SYS_C0042835','INDEX','STORETW','NO','YES','This object name is system generated for station_project (fk_project,fk_station)');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SYS_C0042847','INDEX','STORETW','NO','YES','This object name is system generated for activity_metric_index (fk_activitymetric, fk_bio_habitat_index)');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_SS_HUC_ORG_ID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_SS_HUC','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_HC_HUC','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_HC_HUC_CHARTYPEID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_HOC_HUC_ORGID_CHARTYPEID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBWSPSC_FK_CHART','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBWSPSC_FK_STATIONT','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_ORGID_PROJCD','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_LATITUDE','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_LONGITUDE','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_HUC','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWSPS_CHARTYPE','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_ORG_ACT_FN_ORG_STN_ACT','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_ORG_ACT_PROJ_FN_ORG_ID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_DI_ORG_FN_ORG_ID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFAR_LT_STN_ID_OID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IFAR_LT_ORG_ID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IWS_SS_UNIQUE_STATION_ID','INDEX','STORETW','NO','YES','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FDACT_TEMP','TABLE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FDACT_TEMP2','TABLE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('TSRAAL_AP','TABLE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('TSRAAL_NAP','TABLE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_INTENT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_COMMUNITY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_STATN_TYPES','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_BIO_RES_SOURCE_SYSTEM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_ORG1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_GEO1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_STATN_TYPES','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_LOCATION_POINT_TYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CHAR_ALIAS_ISD_FK_CHAR_TYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_REGULAR_RESULT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_REGULAR_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_ALL','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_CHAR','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_CHAR_COUNTY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_CHAR_STATE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_COUNTY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MV_REGULAR_RESULT_STATE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_FA_REG_RESULT_SOURCEUID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_REG_RES_SOURCE_SYSTEM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEQ_MT_ATTRIBUTE_MAP','SEQUENCE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_STATION_MAP','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_STATION_WEB','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SEM_TAB','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('STATNINFO_TEMP','TABLE','STORETW','NO','NO','This object is not necessary to be present for WQX ETL');
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_PK_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_PK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IBR_STN_ACT_PT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('I_FA_BIO_RESULT_SOURCEUID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_BLOB','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_HABITAT_RESULT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_HABITAT_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_ACT_IS_NUM_ORG_ID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_RESULT_LBRMK_01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_DATE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_ACITIVTY_ISN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_GEO2','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_GEN_DB_CAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_STATION','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_HUC','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_DATE_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_CHAR_DATE_LAT_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_STATE_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_COUNTY_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_HUC_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_PK_DATE_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_PK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHB_STN_ACT_PT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('FA_STATION','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_STATION','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_SID_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_SISN_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_OID','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_LAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_OISN','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_OID_ALP','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_DB4','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_GEN_DB4','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_GEO1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_GEO2','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_MAD_HMETHOD','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_MAD_VMETHOD','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_MAD_HDATUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_MAD_VDATUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_STD_MAD_HDATUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_STD_LAT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('SD_STD_LONG','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_ORG1','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_SD_FK_STATN_TYPES','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_FK_ESTRY_PRIMARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ISD_FK_ESTRY_SECONDARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('HABITAT_RESULT_PROJECT','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHP_FK_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHP_FK_PROJECT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IHP_FK_PROJECT_RESULT','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_CHARTYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CHARTYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('ICHARTYPE01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_CHAR_ALIAS','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('CHAR_ALIAS_ISD_FK_CHAR','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CHAR_ALIAS','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_CHAR_ALIAS_TYPE','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_CHAR_ALIAS_TYPE','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_ESTRY_PRIMARY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ESTRY_PRIMARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IESTRY_PRIMARY01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_ESTRY_SECONDARY','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_ESTRY_SECONDARY','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('IESTRY_SECONDARY01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_EXTERNAL_REF_SCHEME','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_REF_SCHEME','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_MAD_HDATUM','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_MAD_HDATUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('MAD_HDATUM01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_MAD_HMETHOD','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_MAD_HMETHOD','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('LU_MAD_VDATUM','TABLE','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_MAD_VDATUM','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DB_VDATUM01','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('PK_MAD_VMETHOD','INDEX','STORETW','YES','YES',null);
Insert into STORETW.MT_PROD_OBJECTS (ONAME,OTYPE,OWNER,PRE_ETL,PRE_PROD,COMMENT_DESC) values ('DB_VMETHOD01','INDEX','STORETW','YES','YES',null);
--------------------------------------------------------
--  DDL for Index PK_MT_PROD_OBJECTS
--------------------------------------------------------

  CREATE UNIQUE INDEX "STORETW"."PK_MT_PROD_OBJECTS" ON "STORETW"."MT_PROD_OBJECTS" ("ONAME", "OTYPE", "OWNER") 
  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 "STORETDATA_STORMODP" ;
--------------------------------------------------------
--  Constraints for Table MT_PROD_OBJECTS
--------------------------------------------------------

  ALTER TABLE "STORETW"."MT_PROD_OBJECTS" ADD CONSTRAINT "PK_MT_PROD_OBJECTS" PRIMARY KEY ("ONAME", "OTYPE", "OWNER")
  USING INDEX 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 "STORETDATA_STORMODP"  ENABLE;
