Rem Rem Copyright (c) 2004, 2009, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem xoqu102.sql - migration script for upgrading olap api component Rem Rem DESCRIPTION Rem Upgrade OLAP API from 10.2.0 Rem Rem NOTES Rem Rem MODIFIED (MM/DD/YY) Rem wechen 07/29/09 - Backport wechen_bug-8688621 from Rem st_rdbms_11.2.0.1.0 Rem glyon 06/06/08 - drop (deprecated) types on upgrade Rem awesley 04/20/06 - Migrate from xoq101.sql Rem glyon 03/28/06 - drop (deprecated) ODBO elements on upgrade Rem cdalessi 05/26/04 - cdalessi_txn111650 Rem cdalessi 05/26/04 - Creation execute sys.dbms_registry.upgrading('XOQ','Oracle OLAP API','xoq_validate',''); -- drop ODBO support DROP PACKAGE DBMS_XSOQ_ODBO; DROP VIEW olap_oledb_measdims_pvt; DROP VIEW olap_oledb_listdims_pvt; DROP VIEW olap_oledb_stdhiers_pvt; DROP VIEW olap_oledb_stdlevels_pvt; DROP VIEW olap_oledb_cubedims_pvt; DROP VIEW olap_oledb_custprops_pvt; DROP VIEW olap_oledb_level_type_pvt; DROP VIEW olap_oledb_cardinality_pvt; DROP VIEW olap_oledb_dflt_mbr_pvt; DROP VIEW olap_oledb_reg_attrs_pvt; DROP VIEW olap_oledb_cubes; DROP VIEW olap_oledb_dimensions; DROP VIEW olap_oledb_hierarchies; DROP VIEW olap_oledb_levels; DROP VIEW olap_oledb_properties; DROP VIEW olap_oledb_measures; DROP VIEW olap_oledb_actions; DROP VIEW olap_oledb_functions; DROP VIEW olap_oledb_sets; DROP TYPE Olapi_MDX_Rowset_Impl_t FORCE; DROP FUNCTION Olapi_MDX_Rowset_Table; DROP VIEW olap_oledb_mdproperties; DROP TABLE olap_oledb_mdprops; DROP TABLE olap_oledb_mdpropvals; DROP TABLE olap_oledb_keywords; DROP TABLE olap_oledb_functions_pvt; -- drop packages abandoned for RDBMS 11. DROP PACKAGE CursorManagerInterface; DROP PACKAGE DataTypeIdConstants; DROP PACKAGE FunctionIdConstants; DROP PACKAGE ParameterIdConstants; DROP PACKAGE DefinitionManagerInterface; DROP PACKAGE DataProviderInterface; DROP PACKAGE DatabaseInterface; DROP PACKAGE ConnectionInterface; DROP PACKAGE ServerInterface ; DROP PACKAGE MdmObjectIdConstants; DROP PACKAGE MdmPropertyIdConstants; DROP PACKAGE MdmClassConstants; DROP PACKAGE MetadataProviderInterface; DROP PACKAGE InterruptableInterface; -- drop types abandoned for RDBMS 11. DROP TYPE CONNECTIONINTERFACE FORCE; DROP TYPE CURSORMANAGERINTERFACE FORCE; DROP TYPE DATABASEINTERFACE FORCE; DROP TYPE DATAPROVIDERINTERFACE FORCE; DROP TYPE DEFINITIONMANAGERINTERFACE FORCE; DROP TYPE GENBASEONLYDEFINITIONSTRUCT FORCE; DROP TYPE GENBOOLEANSEQUENCE FORCE; DROP TYPE GENCOMPARISONRULEENUM FORCE; DROP TYPE GENCOMPOUNDCURSORBLOCKSEQUENCE FORCE; DROP TYPE GENCOMPOUNDCURSORBLOCKSTRUCT FORCE; DROP TYPE GENCONNECTIONPARAMETERINFOSEQU FORCE; DROP TYPE GENCONNECTIONPARAMETERINFOSTRU FORCE; DROP TYPE GENCONNECTIONPARAMETERTYPEENUM FORCE; DROP TYPE GENCONNECTIONSTRUCT FORCE; DROP TYPE GENCONSTANTLISTDEFINITIONSTRUC FORCE; DROP TYPE GENCONSTANTLISTVALUESUNION FORCE; DROP TYPE GENCURSORBLOCK2SEQUENCE FORCE; DROP TYPE GENCURSORBLOCK2STRUCT FORCE; DROP TYPE GENCURSORBLOCKSEQUENCE FORCE; DROP TYPE GENCURSORBLOCKSTRUCT FORCE; DROP TYPE GENCURSORMANAGERSEQUENCE FORCE; DROP TYPE GENCURSORSPECIFIERSEQUENCE FORCE; DROP TYPE GENCURSORSPECIFIERSEQUENCESEQU FORCE; DROP TYPE GENCURSORSPECIFIERSTRUCT FORCE; DROP TYPE GENCURSORVALUE2UNION FORCE; DROP TYPE GENCURSORVALUE2UNIONSEQUENCE FORCE; DROP TYPE GENCURSORVALUES2UNION FORCE; DROP TYPE GENCURSORVALUESUNION FORCE; DROP TYPE GENCURSORVALUEUNION FORCE; DROP TYPE GENCURSORVALUEUNIONSEQUENCE FORCE; DROP TYPE GENDATA2SEQUENCEUNION FORCE; DROP TYPE GENDATA2UNION FORCE; DROP TYPE GENDATA2UNIONSEQUENCE FORCE; DROP TYPE GENDATABLOCK2SEQUENCE FORCE; DROP TYPE GENDATABLOCK2STRUCT FORCE; DROP TYPE GENDATABLOCKSEQUENCE FORCE; DROP TYPE GENDATABLOCKSTRUCT FORCE; DROP TYPE GENDATASEQUENCEUNION FORCE; DROP TYPE GENDATAUNION FORCE; DROP TYPE GENDATAUNIONSEQUENCE FORCE; DROP TYPE GENDATESEQUENCE FORCE; DROP TYPE GENDEFINITIONPOST92SEQUENCE FORCE; DROP TYPE GENDEFINITIONPOST92UNION FORCE; DROP TYPE GENDEFINITIONSEQUENCE FORCE; DROP TYPE GENDEFINITIONUNION FORCE; DROP TYPE GENDEPENDENCYBLOCKSEQUENCE FORCE; DROP TYPE GENDEPENDENCYBLOCKSEQUENCESEQU FORCE; DROP TYPE GENDEPENDENCYBLOCKSTRUCT FORCE; DROP TYPE GENDEPENDENCYBLOCKUNION FORCE; DROP TYPE GENDOMAINENUM FORCE; DROP TYPE GENDOUBLESEQUENCE FORCE; DROP TYPE GENDYNAMICDEFINITIONSTRUCT FORCE; DROP TYPE GENERRORCLASSENUM FORCE; DROP TYPE GENERRORDESCRIPTIONSEQUENCE FORCE; DROP TYPE GENERRORDESCRIPTIONSTRUCT FORCE; DROP TYPE GENERRORTYPEENUM FORCE; DROP TYPE GENEXPRESSEXCEPTION FORCE; DROP TYPE GENFLOATSEQUENCE FORCE; DROP TYPE GENINCLUDEDDEPENDENCYBLOCKSTRU FORCE; DROP TYPE GENINDEXBLOCKSTRUCT FORCE; DROP TYPE GENINVALIDINDEXSPECIFICATIONEX FORCE; DROP TYPE GENINVALIDMETADATAEXCEPTION FORCE; DROP TYPE GENJOINDEFINITIONSTRUCT FORCE; DROP TYPE GENLONGLONGSEQUENCE FORCE; DROP TYPE GENLONGSEQUENCE FORCE; DROP TYPE GENMETADATADEFINITIONSTRUCT FORCE; DROP TYPE GENMETADATAPROPERTYBAGSEQUENCE FORCE; DROP TYPE GENMETADATAPROPERTYBAGUNION FORCE; DROP TYPE GENMETADATAPROPERTYSEQUENCE FORCE; DROP TYPE GENMETADATAPROPERTYSTRUCT FORCE; DROP TYPE GENMETADATAPROPERTYVALUESUNION FORCE; DROP TYPE GENMULTIPLIERBLOCKSTRUCT FORCE; DROP TYPE GENOCTETSEQUENCE FORCE; DROP TYPE GENPARENTSTARTENDBLOCK2SEQUENC FORCE; DROP TYPE GENPARENTSTARTENDBLOCK2UNION FORCE; DROP TYPE GENPARENTSTARTENDBLOCKSEQUENCE FORCE; DROP TYPE GENPARENTSTARTENDBLOCKUNION FORCE; DROP TYPE GENPERSISTENTSOURCEIDSEQUENCE FORCE; DROP TYPE GENPERSISTENTSOURCEIDSTRUCT FORCE; DROP TYPE GENPROPERTYSEQUENCE FORCE; DROP TYPE GENPROPERTYSTRUCT FORCE; DROP TYPE GENRANGEDEFINITIONSTRUCT FORCE; DROP TYPE GENRECURSIVEJOINDEFINITIONSTRU FORCE; DROP TYPE GENREMOTEAPIVERSIONMISMATCHEXC FORCE; DROP TYPE GENREMOTEAUTHENTICATIONEXCEPTI FORCE; DROP TYPE GENREMOTEOBJECTCLOSEDEXCEPTION FORCE; DROP TYPE GENREMOTESPECIFICATIONUPDATENE FORCE; DROP TYPE GENREMOTETASKINTERRUPTEDEXCEPT FORCE; DROP TYPE GENSERVERSTRUCT FORCE; DROP TYPE GENSHORTSEQUENCE FORCE; DROP TYPE GENSHORTSEQUENCESEQUENCE FORCE; DROP TYPE GENSTRINGSEQUENCE FORCE; DROP TYPE GENUNMATCHEDINPUTSEXCEPTION FORCE; DROP TYPE GENVALUECURSORBLOCKSEQUENCE FORCE; DROP TYPE GENVALUECURSORBLOCKSTRUCT FORCE; DROP TYPE GENVALUEDEFINITIONSTRUCT FORCE; DROP TYPE GENVERSIONINFOSTRUCT FORCE; DROP TYPE INTERRUPTABLEINTERFACE FORCE; DROP TYPE METADATAPROVIDERINTERFACE FORCE; DROP TYPE SERVERINTERFACE FORCE; DROP TYPE SQLBASEONLYDEFINITIONSTRUCT FORCE; DROP TYPE SQLBOOLEANSEQUENCE FORCE; DROP TYPE SQLCOMPARISONRULEENUM FORCE; DROP TYPE SQLCOMPOUNDCURSORBLOCKSEQUENCE FORCE; DROP TYPE SQLCOMPOUNDCURSORBLOCKSTRUCT FORCE; DROP TYPE SQLCONNECTIONPARAMETERINFOSEQ FORCE; DROP TYPE SQLCONNECTIONPARAMETERINFOSEQU FORCE; DROP TYPE SQLCONNECTIONPARAMETERINFOSTRU FORCE; DROP TYPE SQLCONNECTIONPARAMETERTYPEENUM FORCE; DROP TYPE SQLCONNECTIONSTRUCT FORCE; DROP TYPE SQLCONSTANTLISTDEFINITIONSTRUC FORCE; DROP TYPE SQLCONSTANTLISTVALUESUNION FORCE; DROP TYPE SQLCURSORBLOCKSTRUCT FORCE; DROP TYPE SQLCURSORSPECIFIERSEQU FORCE; DROP TYPE SQLCURSORSPECIFIERSEQUENCE FORCE; DROP TYPE SQLCURSORSPECIFIERSTRUCT FORCE; DROP TYPE SQLCURSORVALUESUNION FORCE; DROP TYPE SQLCURSORVALUEUNION FORCE; DROP TYPE SQLCURSORVALUEUNIONSEQUENCE FORCE; DROP TYPE SQLDATABLOCKSEQUENCE FORCE; DROP TYPE SQLDATABLOCKSTRUCT FORCE; DROP TYPE SQLDATASEQUENCEUNION FORCE; DROP TYPE SQLDATAUNION FORCE; DROP TYPE SQLDATAUNIONSEQUENCE FORCE; DROP TYPE SQLDEFINITIONSEQUENCE FORCE; DROP TYPE SQLDEFINITIONUNION FORCE; DROP TYPE SQLDEPENDENCYBLOCKSEQ FORCE; DROP TYPE SQLDEPENDENCYBLOCKSEQUENCE FORCE; DROP TYPE SQLDEPENDENCYBLOCKSEQUENCESEQ FORCE; DROP TYPE SQLDEPENDENCYBLOCKSEQUENCESEQU FORCE; DROP TYPE SQLDEPENDENCYBLOCKSTRUCT FORCE; DROP TYPE SQLDEPENDENCYBLOCKUNION FORCE; DROP TYPE SQLDOMAINENUM FORCE; DROP TYPE SQLDOUBLESEQUENCE FORCE; DROP TYPE SQLDYNAMICDEFINITIONSTRUCT FORCE; DROP TYPE SQLERRORCLASSENUM FORCE; DROP TYPE SQLERRORDESCRIPTIONSEQUENCE FORCE; DROP TYPE SQLERRORDESCRIPTIONSTRUCT FORCE; DROP TYPE SQLERRORTYPEENUM FORCE; DROP TYPE SQLEXPRESSEXCEPTION FORCE; DROP TYPE SQLFLOATSEQUENCE FORCE; DROP TYPE SQLINCLUDEDDEPENDENCYBLOCKSTRU FORCE; DROP TYPE SQLINDEXBLOCKSTRUCT FORCE; DROP TYPE SQLINVALIDINDEXSPECIFICATIONEX FORCE; DROP TYPE SQLJOINDEFINITIONSTRUCT FORCE; DROP TYPE SQLLONGLONGSEQUENCE FORCE; DROP TYPE SQLLONGSEQUENCE FORCE; DROP TYPE SQLMETADATADEFINITIONSTRUCT FORCE; DROP TYPE SQLMETADATAPROPERTYBAGSEQ FORCE; DROP TYPE SQLMETADATAPROPERTYBAGSEQUENCE FORCE; DROP TYPE SQLMETADATAPROPERTYBAGUNION FORCE; DROP TYPE SQLMETADATAPROPERTYSEQUENCE FORCE; DROP TYPE SQLMETADATAPROPERTYSTRUCT FORCE; DROP TYPE SQLMETADATAPROPERTYVALUESUNION FORCE; DROP TYPE SQLMULTIPLIERBLOCKSTRUCT FORCE; DROP TYPE SQLOCTETSEQUENCE FORCE; DROP TYPE SQLOLAPIEXCEPTION FORCE; DROP TYPE SQLPARENTSTARTENDBLOCKSEQUENCE FORCE; DROP TYPE SQLPARENTSTARTENDBLOCKUNION FORCE; DROP TYPE SQLPERSISTENTSOURCEIDSEQUENCE FORCE; DROP TYPE SQLPERSISTENTSOURCEIDSTRUCT FORCE; DROP TYPE SQLPROPERTYSEQ FORCE; DROP TYPE SQLPROPERTYSEQUENCE FORCE; DROP TYPE SQLPROPERTYSTRUCT FORCE; DROP TYPE SQLRANGEDEFINITIONSTRUCT FORCE; DROP TYPE SQLREMOTEAPIVERSIONMISMATCHEXC FORCE; DROP TYPE SQLREMOTEAUTHENTICATIONEXCEPTI FORCE; DROP TYPE SQLREMOTEOBJECTCLOSEDEXCEPTION FORCE; DROP TYPE SQLREMOTESPECIFICATIONUPDATENE FORCE; DROP TYPE SQLREMOTETASKINTERRUPTEDEXCEPT FORCE; DROP TYPE SQLSERVERSTRUCT FORCE; DROP TYPE SQLSHORTSEQU FORCE; DROP TYPE SQLSHORTSEQUENCE FORCE; DROP TYPE SQLSTRINGSEQUENCE FORCE; DROP TYPE SQLUNMATCHEDINPUTSEXCEPTION FORCE; DROP TYPE SQLVALUECURSORBLOCKSEQUENCE FORCE; DROP TYPE SQLVALUECURSORBLOCKSTRUCT FORCE; DROP TYPE SQLVALUEDEFINITIONSTRUCT FORCE; DROP TYPE SQLVERSIONINFOSTRUCT FORCE; DROP TYPE SQLWSTRINGSEQ FORCE; DROP TYPE SQLWSTRINGSEQUENCE FORCE; -- drop synonyms abandoned for RDBMS 11 DROP PUBLIC SYNONYM CursorManagerInterface FORCE; DROP PUBLIC SYNONYM SQLPersistentSourceIdStruct FORCE; DROP PUBLIC SYNONYM SQLPersistentSourceIdSequence FORCE; DROP PUBLIC SYNONYM SQLCursorValuesUnion FORCE; DROP PUBLIC SYNONYM SQLCursorValueUnion FORCE; DROP PUBLIC SYNONYM SQLCursorValueUnionSequence FORCE; DROP PUBLIC SYNONYM SQLDataBlockStruct FORCE; DROP PUBLIC SYNONYM SQLDataBlockSequence FORCE; DROP PUBLIC SYNONYM SQLMultiplierBlockStruct FORCE; DROP PUBLIC SYNONYM SQLParentStartEndBlockUnion FORCE; DROP PUBLIC SYNONYM SQLParentStartEndBlockSequence FORCE; DROP PUBLIC SYNONYM SQLDependencyBlockStruct FORCE; DROP PUBLIC SYNONYM SQLIncludedDependencyBlockStru FORCE; DROP PUBLIC SYNONYM SQLDependencyBlockUnion FORCE; DROP PUBLIC SYNONYM SQLDependencyBlockSeq FORCE; DROP PUBLIC SYNONYM SQLDependencyBlockSequence FORCE; DROP PUBLIC SYNONYM SQLDependencyBlockSequenceSeq FORCE; DROP PUBLIC SYNONYM SQLDependencyBlockSequenceSequ FORCE; DROP PUBLIC SYNONYM SQLIndexBlockStruct FORCE; DROP PUBLIC SYNONYM SQLValueCursorBlockStruct FORCE; DROP PUBLIC SYNONYM SQLValueCursorBlockSequence FORCE; DROP PUBLIC SYNONYM SQLCompoundCursorBlockStruct FORCE; DROP PUBLIC SYNONYM SQLCompoundCursorBlockSequence FORCE; DROP PUBLIC SYNONYM SQLCursorBlockStruct FORCE; DROP PUBLIC SYNONYM SQLCursorSpecifierStruct FORCE; DROP PUBLIC SYNONYM SQLCursorSpecifierSequence FORCE; DROP PUBLIC SYNONYM SQLCursorSpecifierSequ FORCE; DROP PUBLIC SYNONYM SQLRemoteSpecificationUpdateNe FORCE; DROP PUBLIC SYNONYM SQLInvalidIndexSpecificationEx FORCE; DROP PUBLIC SYNONYM SQLUnmatchedInputsException FORCE; DROP PUBLIC SYNONYM DataTypeIdConstants FORCE; DROP PUBLIC SYNONYM FunctionIdConstants FORCE; DROP PUBLIC SYNONYM ParameterIdConstants FORCE; DROP PUBLIC SYNONYM SQLComparisonRuleEnum FORCE; DROP PUBLIC SYNONYM SQLJoinDefinitionStruct FORCE; DROP PUBLIC SYNONYM SQLConstantListValuesUnion FORCE; DROP PUBLIC SYNONYM SQLConstantListDefinitionStruc FORCE; DROP PUBLIC SYNONYM SQLRangeDefinitionStruct FORCE; DROP PUBLIC SYNONYM SQLValueDefinitionStruct FORCE; DROP PUBLIC SYNONYM SQLBaseOnlyDefinitionStruct FORCE; DROP PUBLIC SYNONYM SQLMetadataDefinitionStruct FORCE; DROP PUBLIC SYNONYM SQLDynamicDefinitionStruct FORCE; DROP PUBLIC SYNONYM SQLDefinitionUnion FORCE; DROP PUBLIC SYNONYM SQLDefinitionSequence FORCE; DROP PUBLIC SYNONYM DefinitionManagerInterface FORCE; DROP PUBLIC SYNONYM DataProviderInterface FORCE; DROP PUBLIC SYNONYM SQLOctetSequence FORCE; DROP PUBLIC SYNONYM SQLVersionInfoStruct FORCE; DROP PUBLIC SYNONYM SQLRemoteAuthenticationExcepti FORCE; DROP PUBLIC SYNONYM SQLRemoteAPIVersionMismatchExc FORCE; DROP PUBLIC SYNONYM SQLConnectionParameterTypeEnum FORCE; DROP PUBLIC SYNONYM SQLConnectionParameterInfoStru FORCE; DROP PUBLIC SYNONYM SQLConnectionParameterInfoSequ FORCE; DROP PUBLIC SYNONYM SQLConnectionParameterInfoSeq FORCE; DROP PUBLIC SYNONYM SQLPropertyStruct FORCE; DROP PUBLIC SYNONYM SQLPropertySequence FORCE; DROP PUBLIC SYNONYM SQLConnectionStruct FORCE; DROP PUBLIC SYNONYM SQLServerStruct FORCE; DROP PUBLIC SYNONYM DatabaseInterface FORCE; DROP PUBLIC SYNONYM ConnectionInterface FORCE; DROP PUBLIC SYNONYM ServerInterface FORCE; DROP PUBLIC SYNONYM MdmObjectIdConstants FORCE; DROP PUBLIC SYNONYM MdmPropertyIdConstants FORCE; DROP PUBLIC SYNONYM MdmClassConstants FORCE; DROP PUBLIC SYNONYM SQLMetadataPropertyValuesUnion FORCE; DROP PUBLIC SYNONYM SQLMetadataPropertyStruct FORCE; DROP PUBLIC SYNONYM SQLMetadataPropertySequence FORCE; DROP PUBLIC SYNONYM SQLMetadataPropertyBagUnion FORCE; DROP PUBLIC SYNONYM SQLMetadataPropertyBagSeq FORCE; DROP PUBLIC SYNONYM SQLMetadataPropertyBagSequence FORCE; DROP PUBLIC SYNONYM MetadataProviderInterface FORCE; DROP PUBLIC SYNONYM SQLErrorClassEnum FORCE; DROP PUBLIC SYNONYM SQLDomainEnum FORCE; DROP PUBLIC SYNONYM SQLErrorTypeEnum FORCE; DROP PUBLIC SYNONYM SQLErrorDescriptionStruct FORCE; DROP PUBLIC SYNONYM SQLErrorDescriptionSequence FORCE; DROP PUBLIC SYNONYM SQLExpressException FORCE; DROP PUBLIC SYNONYM SQLRemoteObjectClosedException FORCE; DROP PUBLIC SYNONYM SQLRemoteTaskInterruptedExcept FORCE; DROP PUBLIC SYNONYM SQLWstringSeq FORCE; DROP PUBLIC SYNONYM SQLWstringSequence FORCE; DROP PUBLIC SYNONYM InterruptableInterface FORCE; DROP PUBLIC SYNONYM SQLBooleanSequence FORCE; DROP PUBLIC SYNONYM SQLStringSequence FORCE; DROP PUBLIC SYNONYM SQLShortSequence FORCE; DROP PUBLIC SYNONYM SQLShortSequ FORCE; DROP PUBLIC SYNONYM SQLLongSequence FORCE; DROP PUBLIC SYNONYM SQLLongLongSequence FORCE; DROP PUBLIC SYNONYM SQLFloatSequence FORCE; DROP PUBLIC SYNONYM SQLDoubleSequence FORCE; DROP PUBLIC SYNONYM SQLDataUnion FORCE; DROP PUBLIC SYNONYM SQLDataUnionSequence FORCE; DROP PUBLIC SYNONYM SQLDataSequenceUnion FORCE; Rem Rem Call 11.1 upgrade script Rem @@xoqu111.sql execute sys.dbms_registry.upgraded('XOQ');