Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\upg\fix6062030.sql
-------------------------------------------------------------- -- fix6062030.sql -- -- 07/13/07 CJS -------------------------------------------------------------- -- add new property and propertyUsage: OPTIMIZE_MERGE -------------------------------------------------------------- declare classId number; propertySetId number; propertyId number; begin select elementid into classId from classdefinition_v where name='oracle.wh.service.impl.mapping.component.Table'; select elementid into propertySetId from propertysetdefinition_v where classdefinition=classId and name='PLSQL' and propertytype=2; -- add new property: OPTIMIZE_MERGE insert into propertydefinition_v ( LOADINGPARENT ,DELETIONPARENT ,AGGREGATEDSIGNATURE ,CLASSNAME ,COMPLETED ,CREATEDBY ,CREATIONTIMESTAMP ,CUSTOMERDELETABLE ,CUSTOMEREDITABLE ,CUSTOMERRENAMABLE ,DESCRIPTION ,DISABLED ,EDITABLE ,ELEMENTID ,FROZEN ,GENERATED ,IMPORTED ,LOGICALNAME ,METADATASIGNATURE ,NAME ,NOTE ,NOTM ,PERSISTENT ,SEEDED ,UOID ,UPDATEDBY ,UPDATETIMESTAMP ,VERSION ,ISLOADINGPARENT ,PROPERTYTYPE ,DEFINITIONKEY ,EXPORTCONTROL ,OVERRIDE ,POSITION ,CLASSDEFINITION ,DATATYPE ,ISROLE ,ROLEDEFINITION ,TRANSLATABLE ,ISPASSWORD ,HIDDEN ,PROPERTYREADONLY ,NAMECHECKED ,USERCHOICEALLOWED ,DYNAMICDEFAULT ,INPLACEEDITOR ,CUSTOMEDITOR ,PROPERTYGROUPDEFINITION ) values ( classId , 0 , null , 'PropertyDefinition' , 0 , (select createdby from cmpinstallation_v) , (select creationtimestamp from cmpinstallation_v) , 0 , 0 , 0 , 'Optimize code generated to defer transformations until actually needed' , 0 , 0 , cwmseq.nextval , 0 , 0 , 0 , 'OPTIMIZE_MERGE' , '2ebec2acaf7982186613878879f33d78' , 'OPTIMIZE_MERGE' , null , 0 , null , 1 , '0CA84DCDE8304915991E0A292A89BA4F' , (select updatedby from cmpinstallation_v) , sysdate , null , 0 , 2 , 'optimizeMerge' , 0 , 0 , 67 , classId , 113 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , null , null , null , 0 ); select elementid into propertyId from propertydefinition_v where classdefinition=classId and name='OPTIMIZE_MERGE'; insert into propertyusagedefinition_v ( LOADINGPARENT , DELETIONPARENT , AGGREGATEDSIGNATURE , CLASSNAME , COMPLETED , CREATEDBY , CREATIONTIMESTAMP , CUSTOMERDELETABLE , CUSTOMEREDITABLE , CUSTOMERRENAMABLE , DESCRIPTION , DISABLED , EDITABLE , ELEMENTID , FROZEN , GENERATED , IMPORTED , LOGICALNAME , METADATASIGNATURE , NAME , NOTE , NOTM , PERSISTENT , SEEDED , UOID , UPDATEDBY , UPDATETIMESTAMP , VERSION , ISLOADINGPARENT , PROPERTYSETDEFINITION , PROPERTYDEFINITION , DEFINITIONKEY ) values ( classId , 0 , null , 'PropertyUsageDefinition' , 0 , (select createdby from cmpinstallation_v) , (select creationtimestamp from cmpinstallation_v) , 0 , 0 , 0 , 'Optimize code generated to defer transformations until actually needed' , 0 , 0 , cwmseq.nextval , 0 , 0 , 0 , 'OPTIMIZE_MERGE' , '2ebec2acaf7982186613878879f33d78' , 'OPTIMIZE_MERGE' , null , 0 , null , 1 , '0CA84DCDE8304915991E0A292A89BA4F' , (select updatedby from cmpinstallation_v) , sysdate , null , 0 , propertySetId , propertyId , '8i.MAPPING.TABLE.OPTIMIZE_MERGE' ); end; / commit; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de