CREATE TABLE "CMDBPROFILE" (
                 "DBPROFILE_ID" VARCHAR2(30) NOT NULL, 
                 "COOP_ID" VARCHAR2(10) NOT NULL,
                 "ORA_ADM_USR" VARCHAR2(20) NOT NULL,
                 "ORA_ADM_PWD" VARCHAR2(20) NOT NULL,
                 "ORA_ADM_EXP_USR" VARCHAR2(20) NOT NULL,
                 "ORA_ADM_EXP_PWD" VARCHAR2(20) NOT NULL,
                 "ORA_TARGET_DB_HOST" VARCHAR2(40) NOT NULL,
                 "ORA_TARGET_DB_PORT" VARCHAR2(6) NOT NULL,
                 "ORA_TARGET_DB_SID" VARCHAR2(10) NOT NULL,
                 "ORA_TARGET_USR" VARCHAR2(20) NOT NULL,
                 "ORA_TARGET_PWD" VARCHAR2(20) NOT NULL,
                 "ORA_VERSION" VARCHAR2(10) NOT NULL,
                 "DATAPUMP_DIR" CHAR(1) NOT NULL,
                 "DATAPUMP" VARCHAR2(20) NOT NULL,
                 "ORA_OS_USR" VARCHAR2(20) NOT NULL,
                 "ORA_OS_PWD" VARCHAR2(20) NOT NULL,
                 "NLS_LANG" VARCHAR2(50) NOT NULL,
                 "USED_FLAG" NUMBER(1) DEFAULT 1 NOT NULL ,
                 "BACKUP_PATH" VARCHAR2(250) NOT NULL,
				 "SCRIPT_PATH" VARCHAR2(250) NOT NULL,
				 "SCHEDULER_MON" VARCHAR2(50) DEFAULT '12:20,22:00' NOT NULL,
				 "SCHEDULER_TUE" VARCHAR2(50)  DEFAULT '12:20,22:00' NOT NULL,
				 "SCHEDULER_WED" VARCHAR2(50) DEFAULT '12:20,22:00' NOT NULL,
				 "SCHEDULER_THU" VARCHAR2(50) DEFAULT '12:20,22:00' NOT NULL,
				 "SCHEDULER_FRI" VARCHAR2(50) DEFAULT '12:20,22:00' NOT NULL,
				 "SCHEDULER_SAT" VARCHAR2(50) DEFAULT '12:20,22:00' NOT NULL,
				 "SCHEDULER_SUN" VARCHAR2(50) DEFAULT '12:20,22:00' NOT NULL,
                 "SCHEDULER_DEPLOY_FLAG" NUMBER(1) DEFAULT 0 NOT NULL 
                 ) ;
        ALTER TABLE "CMDBPROFILE" ADD ( CONSTRAINT CMDBPROFILE_PK PRIMARY KEY ( "DBPROFILE_ID","COOP_ID" )) ;