Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\reposupgrade\release111\drop.sql
rem Generated for Warehouse Builder by UML Code Generator drop sequence cwmseq; drop table CMPFCOClasses cascade constraints; drop table CMPMMMClasses cascade constraints; drop table CMPSCOClasses cascade constraints; drop table CMPSCOCfgClasses cascade constraints; drop table CMPSCOMapClasses cascade constraints; drop table CMPSCOPrpClasses cascade constraints; drop table CMPSYSClasses cascade constraints; drop view CMPRelation_V; drop view CMPRelationalDBObject_V; drop view CMPInstalledModule_V; drop view CMPSharedInstalledModule_V; drop view CMPWBDataWarehouse_V; drop view CMPWBFileInstalledModule_V; drop view CMPWBGatewayInstalledModule_V; drop view CMPWBOracleInstalledModule_V; drop view CMPWBPsftInstalledModule_V; drop view CMPWBRepInstalledModule_V; drop view CMPWBSAPInstalledModule_V; drop view CMPXMLInstalledModule_V; drop view CMPBinaryObject_V; drop view CMPIcon_V; drop view CMPBusinessRuleDefinition_V; drop view CMPBusinessRuleItemParam_V; drop view CMPBusinessRuleModule_V; drop view CMPBusinessRuleRelParam_V; drop view CMPBusinessRuleUsage_V; drop view CMPDataRuleMap_V; drop view CMPRelationUsage_V; drop view CMPBusinessTreeShortcut_V; drop view CMPCatalog_V; drop view CMPBaseCapture_V; drop view CMPCaptureRelation_V; drop view CMPCaptureSpec_V; drop view CMPCDCAttributeUsage_V; drop view CMPChangeLog_V; drop view CMPChangeSpec_V; drop view CMPExtRelationalCapture_V; drop view CMPExtStreamsCapture_V; drop view CMPRelationalCapture_V; drop view CMPStreamsCapture_V; drop view CMPWBCaptureAttributeUsage_V; drop view CMPWBRowIDUsage_V; drop view CMPWBTxnIDUsage_V; drop view CMPDatatype_V; drop view CMPLanguage_V; drop view CFA_V; drop view CFAOwner_V; drop view ComponentUnit_V; drop view FirstClassObject_V; drop view Folder_V; drop view OWBClone_V; drop view SecondClassObject_V; drop view CMPConfigurable_V; drop view CMPGenerationResult_V; drop view CMPNamedConfiguration_V; drop view CMPNamedConfigurationUsage_V; drop view CMPPhysicalObject_V; drop view CMPAggregationSpecification_V; drop view CMPAggSpecUsage_V; drop view CMPCompositeDimension_V; drop view CMPCompositeDimensionUsage_V; drop view CMPCube_V; drop view CMPCubeDefAggrMethod_V; drop view CMPCubeDimReference_V; drop view CMPCubeMeasure_V; drop view CMPMeasureFolder_V; drop view CMPMeasureFolderReference_V; drop view CMPMeasureFolderRefItem_V; drop view CMPMeasureReference_V; drop view CMPDMModel_V; drop view CMPDerivationSchema_V; drop view CMPFunctionalDependency_V; drop view CMPInclusionDependency_V; drop view CMPMultiObjectHolder_V; drop view CMPProfile_V; drop view CMPProfileAttribute_V; drop view CMPProfileForeignKey_V; drop view CMPProfileObject_V; drop view CMPProfileTable_V; drop view CMPProfileUniqueKey_V; drop view CMPRdntItemSet_V; drop view CMPRdntItemSetUsage_V; drop view CMPTargetTableUsage_V; drop view CMPTargetUsage_V; drop view CMPDependency_V; drop view CMPDerivationSourceFCO_V; drop view CMPDerivationSourceReference_V; drop view CMPDerivationSourceSCO_V; drop view CMPDerivedFCO_V; drop view CMPDerivedSCO_V; drop view CMPDerivationLink_V; drop view CMPDerivationSet_V; drop view CMPDimension_V; drop view CMPDimensionAttribute_V; drop view CMPDimensionRole_V; drop view CMPHierarchy_V; drop view CMPHierarchyLevelUsage_V; drop view CMPLevel_V; drop view CMPLevelAttribute_V; drop view CMPSkipLevelRelationship_V; drop view CMPWBPsftTreeStrct_V; drop view CMPAbstractType_V; drop view CMPArrayType_V; drop view CMPCollectionType_V; drop view CMPDomain_V; drop view CMPPrimitiveType_V; drop view CMPRange_V; drop view CMPScalarType_V; drop view CMPLocation_V; drop view CMPLocationUsage_V; drop view CMPLogicalConnector_V; drop view CMPLogicalLocation_V; drop view CMPRuntimeLocation_V; drop view CMPRecord_V; drop view CMPWBField_V; drop view CMPWBFile_V; drop view CMPWBFormatMask_V; drop view CMPCobolStructure_V; drop view CMPDependentArray_V; drop view CMPRedefines_V; drop view CMPElement_V; drop view CMPInstallation_V; drop view CMPSupportedLanguage_V; drop view CMPFunction_V; drop view CMPFunctionArgument_V; drop view CMPFunctionCategory_V; drop view CMPFunctionImplementation_V; drop view CMPFunctionParallel_V; drop view CMPPLSCollection_V; drop view CMPPLSRecord_V; drop view CMPPLSRowtype_V; drop view CMPRecordFieldUsage_V; drop view CMPRefCursorType_V; drop view CMPSoftwareModule_V; drop view CMPWBApplicationType_V; drop view CMPWBDSIntegratorMap_V; drop view CMPWBIntegrator_V; drop view CMPWBIntgACETypeUsage_V; drop view CMPWBSystemType_V; drop view CMPWBValidDataTypeList_V; drop view CMPIntellBusAreaShortcut_V; drop view CMPIntelligenceBusArea_V; drop view CMPIntelligenceBusAreaFCO_V; drop view CMPIntelligenceSchema_V; drop view CMPAttribute_V; drop view CMPAttributeArray_V; drop view CMPComplexItem_V; drop view CMPExpressionOwner_V; drop view CMPExpressionVariable_V; drop view CMPExternalTableItem_V; drop view CMPFlexField_V; drop view CMPFlexStructure_V; drop view CMPForeignKey_V; drop view CMPItem_V; drop view CMPItemSet_V; drop view CMPOrderedObject_V; drop view CMPRelationalDBItem_V; drop view CMPStreamsSubstituteKey_V; drop view CMPStructure_V; drop view CMPUnion_V; drop view CMPUniqueKey_V; drop view CMPWBCheckConstraint_V; drop view CMPWBItemSetUsage_V; drop view CMPWBNamedItemSet_V; drop view CMPBaseEmbedMap_V; drop view CMPBaseMap_V; drop view CMPBaseMapOperator_V; drop view CMPEmbedMap_V; drop view CMPEmbedMapOwner_V; drop view CMPMap_V; drop view CMPMapAttribute_V; drop view CMPMapAttributeBindee_V; drop view CMPMapAttributeGroup_V; drop view CMPMapAttributeGroupBindee_V; drop view CMPMapAttributeGroupOwner_V; drop view CMPMapDisplaySet_V; drop view CMPMapDisplaySetBindee_V; drop view CMPMapDisplaySetUsage_V; drop view CMPMapOperator_V; drop view CMPMapOperatorBindee_V; drop view CMPMapOperatorOwner_V; drop view CMPMapOperatorUsage_V; drop view CMPMappable_V; drop view CMPPublicSubMap_V; drop view CMPSubMapLibrary_V; drop view CMPACEType_V; drop view CMPWBACETypeUsage_V; drop view ClassUsageOwner_V; drop view CMPArrayModelAttribute_V; drop view CMPAssociationDefinition_V; drop view CMPClassDefinition_V; drop view CMPClassUsage_V; drop view CMPClassUsageGroup_V; drop view CMPCollectionModelAttribute_V; drop view CMPDefinitionElement_V; drop view CMPDependencyDefinition_V; drop view CMPExtensionModel_V; drop view CMPModelAttribute_V; drop view CMPPrimitiveModelAttribute_V; drop view CMPPropertyDefinition_V; drop view CMPPropertyGroupDefinition_V; drop view CMPPropertyGroupOwner_V; drop view CMPReferenceModelAttribute_V; drop view CMPRegistryEntry_V; drop view CMPRegistryService_V; drop view CMPRoleDefinition_V; drop view CMPScalarModelAttribute_V; drop view CMPTranslatedField_V; drop view CMPWBMIVDefinition_V; drop view CMPWBMIVView_V; drop view CMPMLSTranslatable_V; drop view CMPTranslation_V; drop view CMPAccessControlledElement_V; drop view CMPBaseProcess_V; drop view CMPBaseProcessActivity_V; drop view CMPProcActivParamCandidate_V; drop view CMPProcess_V; drop view CMPProcessActivity_V; drop view CMPProcessActivityParameter_V; drop view CMPProcessInstalledModule_V; drop view CMPProcessPackage_V; drop view CMPProcessTransition_V; drop view CMPProgram_V; drop view CMPProgramGroup_V; drop view CMPSubProcess_V; drop view CMPWBProject_V; drop view CMPCLOBPropertyValue_V; drop view CMPPropertyOwner_V; drop view CMPPropertyValue_V; drop view CMPPurePhysicalObject_V; drop view CMPReferencePropertyValue_V; drop view CMPStringPropertyValue_V; drop view CMPUserDefinedProperty_V; drop view CMPDateHierLevel_V; drop view CMPDateHierTemplate_V; drop view CMPDesignAttribute_V; drop view CMPDesignReference_V; drop view CMPDesignRelation_V; drop view CMPDrillItem_V; drop view CMPDrillLevel_V; drop view CMPDrillPath_V; drop view CMPDrillPathJoinUsage_V; drop view CMPDrillPathSegment_V; drop view CMPIntelligenceItem_V; drop view CMPJoin_V; drop view CMPJoinComponent_V; drop view CMPLOVItemClass_V; drop view CMPObjectJoinUsage_V; drop view CMPQueryCondition_V; drop view CMPQueryExpOwner_V; drop view CMPQueryExpRef_V; drop view CMPQueryItem_V; drop view CMPQueryObject_V; drop view CMPQueryReferencable_V; drop view CMPAdvancedQueue_V; drop view CMPConcreteTypeUsage_V; drop view CMPQueuePropagation_V; drop view CMPQueueTable_V; drop view CMPStreamsApply_V; drop view CMPStreamsApplyTableUsage_V; drop view CMPStreamsDMLHandlerUsage_V; drop view CMPCluster_V; drop view CMPClusterUsage_V; drop view CMPExternalTable_V; drop view CMPIndex_V; drop view CMPPartition_V; drop view CMPPartitionKey_V; drop view CMPTrigger_V; drop view CMPWBMaterializedView_V; drop view CMPWBSequence_V; drop view CMPWBTable_V; drop view CMPWBView_V; drop view CMPReport_V; drop view CMPReportItem_V; drop view CMPReportGroup_V; drop view CMPReportGroupShortcut_V; drop view CMPReportSchema_V; drop view CMPBaseCalendar_V; drop view CMPCalendar_V; drop view CMPCalendarInstalledModule_V; drop view CMPCalendarUsage_V; drop view CMPLocalCalendar_V; drop view CMPTimeWindow_V; drop view Schedulable_V; drop view CMPAccessControlList_V; drop view CMPAccessPreference_V; drop view CMPACLContainer_V; drop view CMPPrivilegeOwner_V; drop view CMPRoleAssignment_V; drop view CMPWBRole_V; drop view CMPWBUser_V; drop view CMPTask_V; drop view CMPTaskFlow_V; drop view CMPTaskFlowInstalledModule_V; drop view CMPTaskFlowSet_V; drop view CMPTaskFlowUsage_V; drop view CMPTaskImplementation_V; drop view CMPTaskInstruction_V; drop view CMPWBOracleDatafile_V; drop view CMPWBOracleTTS_V; drop view CMPWBOracleTTSSet_V; drop view CMPWBOracleTTSUsage_V; drop view CMPAbstractCollection_V; drop view CMPComplexDatatype_V; drop view CMPObjectType_V; drop view CMPRecordField_V; drop view CMPReferenceDatatype_V; drop view CMPSQLCollection_V; drop view CMPTypeDefinition_V; drop view CMPTypedObject_V; drop view CMPValidationComponent_V; drop view CMPWBValidationResult_V; drop view CMPBaseVariable_V; drop view CMPGlobalVariable_V; drop view CMPVariable_V; drop view CMPVariableFolder_V; drop view CMPVariableOwner_V; drop view CMPWeakAssociation_V; drop view CMPWeakComponent_V; drop view CMPWeakFirstClassObject_V; drop view CMPWeakFolder_V; drop view CMPWeakModule_V; drop view CMPWeakSecondClassObject_V; drop view WeakAssociationOwner_V; drop view WeakComponentOwner_V; drop view WeakFirstClassObjectOwner_V; drop view WeakSecondClassObjectOwner_V; drop view CMPWebAnalyticsProcessModule_V; drop view CMPWeblogField_V; drop view CMPWebLogFieldType_V; drop view CMPWeblogFormat_V; drop view CMPWeblogFormatType_V; drop view CMPWeblogParseRule_V; drop view CMPWeblogSource_V; drop view CMPWebPageRule_V; drop view CMPWebReferringSite_V; drop view CMPWebResourceRule_V; drop view CMPWebSearchEngine_V; drop view CMPWebSessionRule_V; drop view CMPWebsite_V; drop view CMPWebsiteInstalledModule_V; drop view CMPWebUserRule_V; drop view CMPWebVisitorRule_V; drop view CMPWebWarehouseModule_V; drop view CMPWorkspace_V; drop view CMPXMLAttribute_V; drop view CMPXMLElement_V; drop view CMPXMLFile_V; drop view CMPXMLForeignKey_V; drop view CMPXMLGroupType_V; drop view CMPXMLSimpleType_V; drop view CMPXMLUniqueKey_V; drop view pctree_v ; drop view interlink_v ; drop view intralink_v ; drop table MCMModelSemantics cascade constraints; Rem 10/18/2007 epaglina drop view were missing for tokyo Rem Added for Repos Upgrade Feature drop view CMPALLWBUSER_V; drop view CMPFCOELEMENT_V; drop view CMPFCOELEMENT_X; drop view CMPFCORELATION_V; drop view CMPFCORELATION_X; drop view CMPSCOCFGELEMENT_V; drop view CMPSCOCFGELEMENT_X; drop view CMPSCOCFGRELATION_V; drop view CMPSCOCFGRELATION_X; drop view CMPSCOELEMENT_V; drop view CMPSCOELEMENT_X; drop view CMPSCOMAPELEMENT_V; drop view CMPSCOMAPELEMENT_X; drop view CMPSCOPRPELEMENT_V; drop view CMPSCOPRPELEMENT_X; drop view CMPSYSELEMENT_V; drop view CMPSYSELEMENT_X;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de