Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\MDLRules92to10.txt
# this is the rule file for the MDL # header information PRODSRCRELEASE=9.1.0.5.0 PRODTGTRELEASE=9.0.3.22.0 SRCRELEASE=9.2 TGTRELEASE=10.0 SRCMDLRELEASE=9.2 TGTMDLRELEASE=10.0 CLASSPATH=oracle.wh.repos.pdl.metadataloader.converter.versions # no comments allowed between BEGIN_HEADER and END_HEADER # unless you want it to appear as part of the header of your target file # <TIMESTAMP> will be replaced with the date and time while <RELEASE> will be replaced with the old release version BEGIN_HEADER #!---------------------------------------------------------------------- #! #! Oracle Warehouse Builder Upgrade Utility <TIMESTAMP> #! Upgraded from 9.2 to 11.1 #! #!---------------------------------------------------------------------- END_HEADER # actual rules # always cache the project for writing the statistics BASELANGUAGE,BASELANGUAGE,2,COPY,CACHE SUPPORTEDLANGUAGE,SUPPORTEDLANGUAGE,2,COPY,CACHE MULTILANGUAGESUPPORT,MULTILANGUAGESUPPORT,2,COPY,CACHE BEGIN_MLSDESCRIPTION,BEGIN_MLSDESCRIPTION END_MLSDESCRIPTION,END_MLSDESCRIPTION METADATADEFINITION,METADATADEFINITION,4,COPY BEGIN_DEFAULTVALUE,BEGIN_DEFAULTVALUE END_DEFAULTVALUE,END_DEFAULTVALUE PROJECT,PROJECT,4,COPY,CACHE PROJECT,PROJECT,5,COPY,CACHE LOCATION,LOCATION,9,COPY,CACHE CONNECTOR,CONNECTOR,7,COPY,CACHE RUNTIMEREPOSITORYCONNECTION,RUNTIMEREPOSITORYCONNECTION,11,COPY,CACHE USERDEFINEDPROPERTY,USERDEFINEDPROPERTY,2,COPY,CACHE TABLE,TABLE,5,COPY,CACHE EXTERNALTABLE,EXTERNALTABLE,13,COPY,CACHE BEGIN_DESCRIPTION,BEGIN_DESCRIPTION END_DESCRIPTION,END_DESCRIPTION BEGIN_ACCESSPARAMETER,BEGIN_ACCESSPARAMETER END_ACCESSPARAMETER,END_ACCESSPARAMETER DATAWAREHOUSE,DATAWAREHOUSE,25,COPY,CACHE DATAWAREHOUSE,DATAWAREHOUSE,3,COPY,CACHE ORACLEINSTALLEDMODULE,ORACLEINSTALLEDMODULE,25,COPY,CACHE ORACLEINSTALLEDMODULE,ORACLEINSTALLEDMODULE,3,COPY,CACHE FILEINSTALLEDMODULE,FILEINSTALLEDMODULE,20,COPY,CACHE FILEINSTALLEDMODULE,FILEINSTALLEDMODULE,3,COPY,CACHE SAPINSTALLEDMODULE,SAPINSTALLEDMODULE,34,COPY,CACHE SAPINSTALLEDMODULE,SAPINSTALLEDMODULE,3,COPY,CACHE SHAREDINSTALLEDMODULE,SHAREDINSTALLEDMODULE,3,COPY,CACHE GATEWAYINSTALLEDMODULE,GATEWAYINSTALLEDMODULE,25,COPY,CACHE,type=0 GATEWAYINSTALLEDMODULE,GATEWAYINSTALLEDMODULE,3,COPY,CACHE,type=0 #COLLECTION,COLLECTION,3,COPY #COLLECTIONSHORTCUT,COLLECTIONSHORTCUT,14,COPY,CACHE VIEW,VIEW,5,COPY,CACHE MATERIALIZEDVIEW,MATERIALIZEDVIEW,5,COPY,CACHE BEGIN_NOTE,BEGIN_NOTE END_NOTE,END_NOTE BEGIN_PACKAGESPEC,BEGIN_PACKAGESPEC END_PACKAGESPEC,END_PACKAGESPEC BEGIN_PACKAGEBODY,BEGIN_PACKAGEBODY END_PACKAGEBODY,END_PACKAGEBODY BEGIN_SELECT,BEGIN_SELECT END_SELECT,END_SELECT SEQUENCE,SEQUENCE,5,COPY,CACHE DIMENSION,DIMENSION,7,COPY,CACHE DIMENSION,DIMENSION,5,COPY,CACHE LEVEL,LEVEL,6,COPY,CACHE COLUMN,COLUMN,16,COPY,CACHE COLUMN,COLUMN,15,COPY,CACHE COLUMN,COLUMN,12,COPY,CACHE HIERARCHY,HIERARCHY,9,COPY,CACHE LEVELRELATIONSHIP,LEVELRELATIONSHIP,8,COPY,CACHE FACT,FACT,6,COPY,CACHE MEASURE,MEASURE,12,COPY,CACHE CHECKCONSTRAINT,CHECKCONSTRAINT,5,COPY,CACHE BEGIN_CONDITION,BEGIN_CONDITION END_CONDITION,END_CONDITION PRIMARYKEY,PRIMARYKEY,COPY,CACHE UNIQUEKEY,UNIQUEKEY,COPY,CACHE FOREIGNKEY,FOREIGNKEY,COPY,CACHE FACTFOREIGNKEY,FACTFOREIGNKEY,COPY,CACHE FACTFOREIGNKEYCOLUMN,FACTFOREIGNKEYCOLUMN,COPY,CACHE SEGMENTEDUNIQUEKEY,SEGMENTEDUNIQUEKEY,5,COPY,CACHE ADVANCEDQUEUE,ADVANCEDQUEUE,6,COPY,CACHE OBJECTTYPE,OBJECTTYPE,3,COPY,CACHE TYPEFIELD,TYPEFIELD,9,COPY,CACHE STANDALONEFUNCTION,STANDALONEFUNCTION,0,COPY,CACHE STANDALONEPROCEDURE,STANDALONEROCEDURE,0,COPY,CACHE FUNCTIONCATEGORY,FUNCTIONCATEGORY,6,COPY,CACHE FUNCTION,FUNCTION,10,COPY,CACHE PARAMETER,PARAMETER,9,COPY,CACHE IMPLEMENTATION,IMPLEMENTATION,5,COPY,CACHE BEGIN_SYNTAX,BEGIN_SYNTAX END_SYNTAX,END_SYNTAX BEGIN_UPDATE_WHERE,BEGIN_UPDATE_WHERE END_UPDATE_WHERE,END_UPDATE_WHERE BEGIN_DELETE_WHERE,BEGIN_DELETE_WHERE END_DELETE_WHERE,END_DELETE_WHERE NAMEDATTRIBUTESET,NAMEDATTRIBUTESET,6,COPY,CACHE NAMEDATTRIBUTESETATTR,NAMEDATTRIBUTESETATTR,3,COPY,CACHE CONFIGPARAM,CONFIGPARAM,5,COPY,CACHE CHILDCONFIG,CHILDCONFIG,5,COPY,CACHE CONFIGURABLE,CONFIGURABLE,4,COPY,CACHE FILE,FILE,19,COPY,CACHE RECORD,RECORD,5,COPY,CACHE FIELD,FIELD,17,COPY,CACHE MAPPING,MAPPING,7,COPY,CACHE BEGIN_EXPRESSION,BEGIN_EXPRESSION END_EXPRESSION,END_EXPRESSION MAPPINGSTAGECOMPONENT,MAPPINGSTAGECOMPONENT,19,COPY,CACHE MAPPINGSTAGECOMPONENTPROPERTY,MAPPINGSTAGECOMPONENTPROPERTY,4,COPY,CACHE MAPPINGPARAMETERGROUP,MAPPINGPARAMETERGROUP,22,COPY,CACHE MAPPINGPARAMETERGROUPPROPERTY,MAPPINGPARAMETERGROUPPROPERTY,4,COPY,CACHE MAPPINGPARAMETER,MAPPINGPARAMETER,10,COPY,CACHE MAPPINGPARAMETERPROPERTY,MAPPINGPARAMETERPROPERTY,4,COPY,CACHE MAPPINGPARAMETERCONNECTION,MAPPINGPARAMETERCONNECTION,18,COPY,CACHE MAPPINGPHYSICALPROPERTY,MAPPINGPHYSICALPROPERTY,4,COPY,CACHE MAPPINGDISPLAYSET,MAPPINGDISPLAYSET,6,COPY,CACHE MAPPINGDISPLAYSETPARAMETER,MAPPINGDISPLAYSETPARAMETER,3,COPY,CACHE PHYSICALMAPPINGSTEP,PHYSICALMAPPINGSTEP,3,COPY,CACHE PHYSICALMAPPINGSTEPPROPERTY,PHYSICALMAPPINGSTEPPROPERTY,4,COPY,CACHE PHYSICALSTAGECOMPONENTPROPERTY,PHYSICALSTAGECOMPONENTPROPERTY,4,COPY,CACHE BEGIN_PROPERTYVALUE,BEGIN_PROPERTYVALUE END_PROPERTYVALUE,END_PROPERTYVALUE PROCESSMODULE,PROCESSMODULE,17,COPY,CACHE PROCESSPACKAGE,PROCESSPACKAGE,3,COPY,CACHE PROCESS,PROCESS,5,COPY,CACHE CURRENTPROCESSPACKAGE,3,COPY,CACHE CURRENTPROCESS,3,COPY,CACHE PROCESSACTIVITY,PROCESSACTIVITY,18,COPY,CACHE PROCESSACTIVITYPARAMETER,PROCESSACTIVITYPARAMETER,10,COPY,CACHE BEGIN_DATAVALUE,BEGIN_DATAVALUE END_DATAVALUE,END_DATAVALUE SUBPROCESS,SUBPROCESS,13,COPY,CACHE PROCESSTRANSITION,PROCESSTRANSITION,5,COPY,CACHE BEGIN_TRANSITIONCONDITION,BEGIN_TRANSITIONCONDITION END_TRANSITIONCONDITION,END_TRANSITIONCONDITION COLLECTION,COLLECTION,3,COPY,CACHE COLLECTIONSHORTCUT,COLLECTIONSHORTCUT,14,COPY,CACHE INTELLIGENCEMODULE,INTELLIGENCEMODULE,15,COPY,CACHE QUERYOBJECT,QUERYOBJECT,8,COPY,CACHE QUERYITEM,QUERYITEM,33,COPY,CACHE LOV,LOV,8,COPY,CACHE IOBUSINESSAREA,IOBUSINESSAREA,4,COPY,CACHE IOBUSINESSAREASHORTCUT,IOBUSINESSAREASHORTCUT,6,COPY,CACHE CURRENTQUERYOBJECT,CURRENTQUERYOBJECT,5,COPY,CACHE JOIN,JOIN,16,COPY,CACHE JOINCOMPONENT,JOINCOMPONENT,13,COPY,CACHE DRILLPATH,DRILLPATH,12,COPY,CACHE DRILLLEVEL,DRILLLEVEL,6,COPY,CACHE DRILLITEM,DRILLITEM,6,COPY,CACHE DRILLPATHSEGMENT,DRILLPATHSEGMENT,7,COPY,CACHE REPORTMODULE,REPORTMODULE,15,COPY,CACHE REPORT,REPORT,8,COPY,CACHE REPORTITEM,REPORTITEM,16,COPY,CACHE REPORTGROUP,REPORTGROUP,4,COPY,CACHE REPORTGROUPSHORTCUT,REPORTGROUPSHORTCUT,7,COPY,CACHE DERIVATIONSOURCEFCO,DERIVATIONSOURCEFCO,11,COPY,CACHE DERIVATIONSOURCESCO,DERIVATIONSOURCESCO,16,COPY,CACHE DERIVEDFCO,DERIVEDFCO,3,COPY,CACHE PARENTDERIVEDFCO,PARENTDERIVEDFCO,5,COPY,CACHE SNAPSHOT,SNAPSHOT,5,COPY,CACHE SNAPSHOTROOT,SNAPSHOTROOT,5,COPY,CACHE # generic manipulation of MDL to XML conversion TRIGGERACTION,[GENERIC],1,0,WBUpgrade92to10.handleGenericTransformation # END Output the remaining objects and the END tags TRIGGERACTION,[END],1,0,WBUpgrade92to10.processRemainingObjects TRIGGERACTION,[END],2,0,WBUpgrade92to10.writeRemainingObjects TRIGGERACTION,[END],3,0,WBUpgrade92to10.writeXMLEndTags # BEGIN / END text string conversions TRIGGERACTION,[BEGIN_DESCRIPTION],1,0,WBUpgrade92to10.processBeginDescription TRIGGERACTION,[BEGIN_EXPRESSION],1,0,WBUpgrade92to10.processBeginExpression TRIGGERACTION,[BEGIN_PROPERTYVALUE],1,0,WBUpgrade92to10.processBeginPropertyValue TRIGGERACTION,[BEGIN_ACCESSPARAMETER],1,0,WBUpgrade92to10.processBeginAccessParameter TRIGGERACTION,[BEGIN_CONDITION],1,0,WBUpgrade92to10.processBeginCondition TRIGGERACTION,[BEGIN_DATAVALUE],1,0,WBUpgrade92to10.processBeginDataValue TRIGGERACTION,[BEGIN_NOTE],1,0,WBUpgrade92to10.processBeginNote TRIGGERACTION,[BEGIN_PACKAGESPEC],1,0,WBUpgrade92to10.processBeginPackageSpec TRIGGERACTION,[BEGIN_PACKAGEBODY],1,0,WBUpgrade92to10.processBeginPackageBody TRIGGERACTION,[BEGIN_SYNTAX],1,0,WBUpgrade92to10.processBeginSyntax TRIGGERACTION,[BEGIN_SELECT],1,0,WBUpgrade92to10.processBeginSelect TRIGGERACTION,[BEGIN_TRANSITIONCONDITION],1,0,WBUpgrade92to10.processBeginTransitionCondition TRIGGERACTION,[BEGIN_MLSDESCRIPTION],1,0,WBUpgrade92to10.processBeginMLSDescription TRIGGERACTION,[BEGIN_DEFAULTVALUE],1,0,WBUpgrade92to10.processBeginDefaultValue # Environment Upgrade TRIGGERACTION,[PROJECT],1,0,WBUpgrade92to10.processProject TRIGGERACTION,[PROJECT],2,1,WBUpgrade92to10Environment.processProjectLocations TRIGGERACTION,[RUNTIMEREPOSITORYCONNECTION],1,0,WBUpgrade92to10.processGlobalSharedProject TRIGGERACTION,[RUNTIMEREPOSITORYCONNECTION],2,1,WBUpgrade92to10Environment.processRuntimeRepositoryConnection # File Upgrade TRIGGERACTION,[FILE],1,0,WBUpgrade92to10.processFile TRIGGERACTION,[FIELD],1,0,WBUpgrade92to10.processField # Module Status Upgrade TRIGGERACTION,[DATAWAREHOUSE;ORACLEINSTALLEDMODULE;GATEWAYINSTALLEDMODULE;FILEINSTALLEDMODULE;SAPINSTALLEDMODULE;PROCESSMODULE],1,0,WBUpgrade92to10Application.processModuleStatus # Module Location Upgrade TRIGGERACTION,[DATAWAREHOUSE;ORACLEINSTALLEDMODULE;GATEWAYINSTALLEDMODULE;FILEINSTALLEDMODULE;SAPINSTALLEDMODULE;PROCESSMODULE],2,1,WBUpgrade92to10Application.processModuleLocation # Data Warehouse Upgrade TRIGGERACTION,[DATAWAREHOUSE],3,0,WBUpgrade92to10Application.processDataWarehouse # Oracle Installed Module Upgrade TRIGGERACTION,[ORACLEINSTALLEDMODULE],3,0,WBUpgrade92to10Application.processOracleInstalledModule # Process Flow Module Upgrade TRIGGERACTION,[PROCESSMODULE],3,0,WBUpgrade92to10Application.processProcessFlowModule # Process Flow Module Upgrade TRIGGERACTION,[GATEWAYINSTALLEDMODULE],3,0,WBUpgrade92to10Application.processGatewayInstalledModule # Named Attribute Set Upgrade TRIGGERACTION,[NAMEDATTRIBUTESET],2,0,WBUpgrade92to10Relational.processNamedAttributeSet TRIGGERACTION,[NAMEDATTRIBUTESETATTR],2,0,WBUpgrade92to10Relational.processNamedAttributeSetItem # Constraints Upgrade TRIGGERACTION,[UNIQUEKEY],3,1,WBUpgrade92to10Relational.processUniqueKeyAssociations TRIGGERACTION,[PRIMARYKEY],3,0,WBUpgrade92to10Relational.processPrimaryKey TRIGGERACTION,[PRIMARYKEY],4,1,WBUpgrade92to10Relational.processUniqueKeyAssociations # Transformation Upgrade TRIGGERACTION,[FUNCTION],1,0,WBUpgrade92to10.processFunction TRIGGERACTION,[FUNCTION],2,1,WBUpgrade92to10.processFunctionReturnType TRIGGERACTION,[STANDALONEFUNCTION],1,0,WBUpgrade92to10.ignoreKeywords TRIGGERACTION,[STANDALONEPROCEDURE],1,0,WBUpgrade92to10.ignoreKeywords # Sequence Upgrade TRIGGERACTION,[SEQUENCE],1,1,WBUpgrade92to10Relational.processSequence # Dimension Upgrade TRIGGERACTION,[DIMENSION],1,0,WBUpgrade92to10Dimensional.identifyDimensionProcessing TRIGGERACTION,[DIMENSION],2,1,WBUpgrade92to10Dimensional.processDimension TRIGGERACTION,[COLUMN],2,0,WBUpgrade92to10Dimensional.processDimensionColumn TRIGGERACTION,[UNIQUEKEY;PRIMARYKEY],2,0,WBUpgrade92to10Dimensional.processDimensionUniqueKey TRIGGERACTION,[CHECKCONSTRAINT],1,0,WBUpgrade92to10Dimensional.processDimensionCheckConstraint TRIGGERACTION,[NAMEDATTRIBUTESET],1,0,WBUpgrade92to10Dimensional.processDimensionNamedAttributeSet TRIGGERACTION,[NAMEDATTRIBUTESETATTR],1,0,WBUpgrade92to10Dimensional.processDimensionNamedAttributeItem TRIGGERACTION,[MULTILANGUAGESUPPORT],2,0,WBUpgrade92to10Dimensional.processDimensionMultiLanguageSupport # Level Upgrade TRIGGERACTION,[LEVEL],1,1,WBUpgrade92to10Dimensional.processLevel TRIGGERACTION,[COLUMN],1,0,WBUpgrade92to10Dimensional.processLevelAttribute TRIGGERACTION,[UNIQUEKEY;PRIMARYKEY],1,0,WBUpgrade92to10Dimensional.processLevelUniqueKey # Hierarchy Upgrade TRIGGERACTION,[HIERARCHY],1,0,WBUpgrade92to10Dimensional.processHierarchy TRIGGERACTION,[LEVELRELATIONSHIP],1,0,WBUpgrade92to10Dimensional.processLevelRelationship # Cube Upgrade TRIGGERACTION,[FACT],1,1,WBUpgrade92to10Dimensional.processCube TRIGGERACTION,[MEASURE],1,0,WBUpgrade92to10Dimensional.processMeasure TRIGGERACTION,[COLUMN],3,0,WBUpgrade92to10Dimensional.processCubeColumn TRIGGERACTION,[CHECKCONSTRAINT],2,0,WBUpgrade92to10Dimensional.processCubeCheckConstraint TRIGGERACTION,[MULTILANGUAGESUPPORT],3,0,WBUpgrade92to10Dimensional.processCubeMultiLanguageSupport # External Table Upgrade TRIGGERACTION,[EXTERNALTABLE],1,0,WBUpgrade92to10Relational.processExternalTable TRIGGERACTION,[COLUMN],4,0,WBUpgrade92to10Relational.processExternalTableColumn # End of FCO Upgrade TRIGGERACTION,[ENDOFFCO],1,0,WBUpgrade92to10.processRemainingObjects TRIGGERACTION,[ENDOFFCO],2,0,WBUpgrade92to10.writePreviousFCO # Mapping Upgrade TRIGGERACTION,[MAPPING],1,1,WBUpgrade92to10Mapping.processMapping TRIGGERACTION,[MAPPINGSTAGECOMPONENT],1,0,WBUpgrade92to10Mapping.processMappingStageComponent TRIGGERACTION,[MAPPINGPARAMETERGROUP],1,0,WBUpgrade92to10Mapping.processMappingParameterGroup TRIGGERACTION,[MAPPINGPARAMETER],1,0,WBUpgrade92to10Mapping.processMappingParameter TRIGGERACTION,[MAPPINGDISPLAYSET],1,0,WBUpgrade92to10Mapping.processMappingDisplaySet TRIGGERACTION,[MAPPINGDISPLAYSETPARAMETER],1,0,WBUpgrade92to10Mapping.processMappingDisplaySetParameter TRIGGERACTION,[MAPPINGPARAMETERCONNECTION],1,0,WBUpgrade92to10Mapping.processMappingParameterConnection TRIGGERACTION,[MAPPINGSTAGECOMPONENTPROPERTY;PHYSICALSTAGECOMPONENTPROPERTY;MAPPINGPHYSICALPROPERTY;MAPPINGPARAMETERGROUPPROPERTY;MAPPINGPARAMETERPROPERTY;PHYSICALMAPPINGSTEPPROPERTY],1,0,WBUpgrade92to10Mapping.processMappingProperty # Process Flow Upgrade TRIGGERACTION,[CURRENTPROCESSPACKAGE],1,0,WBUpgrade92to10ProcessFlow.processProcessFlowPackage TRIGGERACTION,[CURRENTPROCESS],1,0,WBUpgrade92to10ProcessFlow.processProcessFlowProcess TRIGGERACTION,[PROCESSACTIVITY],1,0,WBUpgrade92to10ProcessFlow.processProcessActivity TRIGGERACTION,[PROCESSACTIVITYPARAMETER],1,0,WBUpgrade92to10ProcessFlow.processProcessActivityParameter TRIGGERACTION,[SUBPROCESS],1,0,WBUpgrade92to10ProcessFlow.processProcessSubProcess TRIGGERACTION,[PROCESSTRANSITION],1,0,WBUpgrade92to10ProcessFlow.processProcessTransition # Collection Upgrade TRIGGERACTION,[COLLECTION],1,0,WBUpgrade92to10Collection.processCollection TRIGGERACTION,[COLLECTIONSHORTCUT],1,0,WBUpgrade92to10Collection.processCollectionShortcut # Metadata Defintion Upgrade TRIGGERACTION,[METADATADEFINITION],1,0,WBUpgrade92to10.processMetadataDefinition TRIGGERACTION,[USERDEFINEDPROPERTY],1,0,WBUpgrade92to10.processUserDefinedProperty # GLH 03/13/06 Added for bug 5082664 to keep track of current snapshot being processed. TRIGGERACTION,[SNAPSHOT],1,0,WBUpgrade92to10.processSnapshot TRIGGERACTION,[SNAPSHOTROOT],1,0,WBUpgrade92to10.processSnapshotRoot # EPS 9/28/06 Bug 5559929 TRIGGERACTION,[MULTILANGUAGESUPPORT],1,0,WBUpgrade92to10.processMLS
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de