Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\PropertyUpgrade.sql

update cmpstringpropertyvalue_v
  set value='INSERT_UPDATE'
  where logicalname = 'DATAENTITY.PARMETERS.LOADTYPE'
        and value='INSERT/UPDATE';

update cmpstringpropertyvalue_v
  set value='UPDATE_INSERT'
  where logicalname = 'DATAENTITY.PARMETERS.LOADTYPE'
        and value='UPDATE/INSERT';

update cmpstringpropertyvalue_v
  set value='TRUNCATE_INSERT'
  where logicalname = 'DATAENTITY.PARMETERS.LOADTYPE'
        and value='TRUNCATE/INSERT';

update cmpstringpropertyvalue_v
  set value='DELETE_INSERT'
  where logicalname = 'DATAENTITY.PARMETERS.LOADTYPE'
        and value='DELETE/INSERT';

update cmpstringpropertyvalue_v
  set value='CHECK_INSERT'
  where logicalname = 'DATAENTITY.PARMETERS.LOADTYPE'
        and value='CHECK/INSERT';

update cmpstringpropertyvalue_v
  set value='YES'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING'
        and value='Yes';

update cmpstringpropertyvalue_v
  set value='NO'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING'
        and value='No';

update cmpstringpropertyvalue_v
  set value='YES'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING'
        and value='Yes';

update cmpstringpropertyvalue_v
  set value='NO'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING'
        and value='No';

update cmpstringpropertyvalue_v
  set value='YES'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING'
        and value='Yes';

update cmpstringpropertyvalue_v
  set value='NO'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING'
        and value='No';

update cmpstringpropertyvalue_v
  set value='YES'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING'
        and value='Yes';

update cmpstringpropertyvalue_v
  set value='NO'
  where logicalname = 'DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING'
        and value='No';

update cmpstringpropertyvalue_v
  set value='OS_EXECUTABLE'
  where logicalname = 'EXTERNAL_PROCESS_KEY'
        and value='OS Executable';

update cmpstringpropertyvalue_v
  set value='PURE_INTEGRATE'
  where logicalname = 'EXTERNAL_PROCESS_KEY'
        and value='Pure Integrate';

update cmpstringpropertyvalue_v
  set value='PURE_EXTRACT'
  where logicalname = 'EXTERNAL_PROCESS_KEY'
        and value='Pure Extract';

update cmpstringpropertyvalue_v
  set value='NO_INDEX'
  where logicalname = '8i.INDEXES.INDEXTYPE'
        and value=' ';

update cmpstringpropertyvalue_v
  set value='NO_INDEX'
  where logicalname = '8i.MVINDEXES.INDEXTYPE'
        and value=' ';

update cmpstringpropertyvalue_v
  set value='ON_DEMAND'
  where logicalname = '8i.MATERIALIZEDVIEWS.REFRESH'
        and value='ON DEMAND';

update cmpstringpropertyvalue_v
  set value='ON_COMMIT'
  where logicalname = '8i.MATERIALIZEDVIEWS.REFRESH'
        and value='ON COMMIT';

update cmpstringpropertyvalue_v
  set value='NO_INDEX'
  where logicalname = '8i.DIMINDEXES.INDEXTYPE'
        and value=' ';

update cmpstringpropertyvalue_v
  set value='NONE'
  where logicalname = '8i.ORACLE8.1.AUDITLEVEL'
        and value='None';

update cmpstringpropertyvalue_v
  set value='STATISTICS'
  where logicalname = '8i.ORACLE8.1.AUDITLEVEL'
        and value='Statistics';

update cmpstringpropertyvalue_v
  set value='ERROR_DETAILS'
  where logicalname = '8i.ORACLE8.1.AUDITLEVEL'
        and value='Error Details';

update cmpstringpropertyvalue_v
  set value='COMPLETE'
  where logicalname = '8i.ORACLE8.1.AUDITLEVEL'
        and value='Complete';

update cmpstringpropertyvalue_v
  set value='NONE'
  where logicalname = '8i.SS.ORACLE8.1.1SS.AUDITLEVEL'
        and value='None';

update cmpstringpropertyvalue_v
  set value='STATISTICS'
  where logicalname = '8i.SS.ORACLE8.1.1SS.AUDITLEVEL'
        and value='Statistics';

update cmpstringpropertyvalue_v
  set value='ERROR_DETAILS'
  where logicalname = '8i.SS.ORACLE8.1.1SS.AUDITLEVEL'
        and value='Error Details';

update cmpstringpropertyvalue_v
  set value='COMPLETE'
  where logicalname = '8i.SS.ORACLE8.1.1SS.AUDITLEVEL'
        and value='Complete';

update cmpstringpropertyvalue_v
  set value='NOT_PARTITIONED'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Not Partitioned';

update cmpstringpropertyvalue_v
  set value='YEAR'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Year';

update cmpstringpropertyvalue_v
  set value='QUARTER'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Quarter';

update cmpstringpropertyvalue_v
  set value='MONTH'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Month';

update cmpstringpropertyvalue_v
  set value='WEEK'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Week';

update cmpstringpropertyvalue_v
  set value='DAY'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Day';

update cmpstringpropertyvalue_v
  set value='HOUR'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Hour';

update cmpstringpropertyvalue_v
  set value='MINUTE'
  where logicalname = '8i.MAPPING.ENTITY.PARTITIONGRANULARITY'
        and value='Minute';

update cmpstringpropertyvalue_v
  set value='NONE'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL'
        and value='None';

update cmpstringpropertyvalue_v
  set value='STATISTICS'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL'
        and value='Statistics';

update cmpstringpropertyvalue_v
  set value='ERROR_DETAILS'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL'
        and value='Error details';

update cmpstringpropertyvalue_v
  set value='COMPLETE'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL'
        and value='Complete';

update cmpstringpropertyvalue_v
  set value='SET_BASED'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE'
        and value='Set based';

update cmpstringpropertyvalue_v
  set value='ROW_BASED'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE'
        and value='Row based';

update cmpstringpropertyvalue_v
  set value='ROW_BASED_TARGET_ONLY'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE'
        and value='Row based (target only)';

update cmpstringpropertyvalue_v
  set value='SET_BASED_FAIL_OVER_TO_ROW_BASED'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE'
        and value='Set based fail over to row based';

update cmpstringpropertyvalue_v
  set value='SET_BASED_FAIL_OVER_TO_ROW_BASED_TARGET_ONLY'
  where logicalname = '8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE'
        and value='Set based fail over to row based (target only)';

commit;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de