Rem Rem $Header: sdo/admin/catmd10i.sql /main/44 2008/07/28 09:24:40 yhu Exp $ Rem Rem catmd10i.sql Rem Rem Copyright (c) 2002, 2008, Oracle. All rights reserved. Rem Rem NAME Rem catmd10i.sql - catmd for all new 10i packages Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem yhu 07/23/08 - move sdopopt to catmdloc.sql Rem yhu 07/10/08 - add sdopopt for spatial part. pruning using query Rem rewrite Rem sdas 06/17/07 - add sdosemdgu Rem alwu 06/01/07 - add downgrade package into 11g install Rem sdas 05/05/07 - do not create rdf type or packages Rem sravada 05/11/07 - Rem jcwang 11/27/06 - add sdo_net_partition - NDM LOD partition package Rem jcwang 09/18/06 - move router pkg (sdortprt) before NDM pkgs Rem wexu 08/18/06 - lrg 2460773 Rem alwu 06/05/06 - factor out RDF/SEM sources into catsem10i.sql Rem alwu 06/05/06 - add owlfast inference and validation Rem alwu 04/18/06 - add logging framework and application context Rem zzhang 04/18/06 - add sdo_geor_admin package Rem rkothuri 04/07/06 - Rem syuditsk 01/29/06 - add sdogrjar.sql Rem zzhang 12/08/05 - change header file execution order Rem nalexand 05/06/05 - add sdordfxh.sql sdordfxb.plb for RDF Rem zzhang 04/21/05 - call sdo_geor_int header file before prvtgrs.sql Rem nalexand 04/22/05 - remove sdordfl.sql: contents in create_rdf_network() Rem sravada 04/01/05 - Add RDF files Rem ningan 02/18/05 - replace sdonetmem.sql with sdonetmemh.sql and sdonetmemb.plb Rem qxie 02/03/05 - add prvtgrlt.sql Rem ningan 12/19/04 - replace sdonetch.sql with sdonetmem.sql Rem rkothuri 09/22/04 - dont install prvtccbk.plb Rem ningan 08/30/04 - Add sdonetch.sql Rem sravada 06/16/04 - Rem fjlee 10/20/03 - Add sdotopomap package Rem qxie 06/02/03 - prvtgruh.sql and prvtgrub.sql renamed Rem sravada 04/21/03 - Rem sravada 04/16/03 - fix indextype creation Rem rkothuri 02/04/03 - change sdocmctbk, prvtcmtcbk to ccbks Rem sravada 01/24/03 - remove connect Rem rkothuri 01/13/03 - conditionally include sdogrxml.sql Rem rkothuri 12/23/02 - add cmtcbk sql files Rem jcwang 12/10/02 - Rem qxie 11/15/02 - add sdo_geor_utl package Rem jcwang 11/12/02 - Add Network Manager Administration PL/SQL packages Rem rkothuri 10/08/02 - Add sdosam and prvtsam Rem sravada 10/03/02 - break topo type header/body Rem syuditsk 08/13/02 - removing sdogcdrb.sql entry Rem syuditsk 08/07/02 - adding entry for sdogcdrh.sql and sdogcdrb.sql Rem sravada 07/26/02 - Rem sravada 07/19/02 - sravada_topo_metadata_views Rem sravada 07/19/02 - Rem sravada 07/19/02 - add Georaster components Rem sravada 07/19/02 - Rem sravada 07/19/02 - Created Rem Rem Topo packages and Types Rem Topo pakcage Header @@sdotopoh.sql Rem TopoMap package header @@sdotpmph.sql REM Topology Types @@prvtptyp.plb Rem Topo pakcage body @@sdotopob.plb Rem Topo indexes, operators @@prvttpop.plb Rem GeoRaster Packages and Types Rem Load the GeoRaster components: Rem Object types and grant permissions Rem GeoRaster metadata XML schema Rem Sysdata table and views Rem SDO_GEOR package Rem SDO_GEOR_UTL package Rem GeoRaster internal packages --prompt Installing GeoRaster Components ... @@sdogrt.sql @@sdogrtg.sql @@sdogrjar.sql -- dbms_registry script seems to work only from sysdba. alter session set current_schema=SYS; COLUMN raster_name NEW_VALUE raster_file NOPRINT; SELECT dbms_registry.script('XDB', '@sdogrxml.sql') AS raster_name FROM DUAL; alter session set current_schema=MDSYS; @&raster_file --@@sdogrxml.sql @@sdogr.sql @@prvtgrih.plb @@prvtgrxh.plb @@sdogra.sql @@sdogru.sql -- lrg 2460773 @@prvtgr.plb @@prvtgrs.plb @@prvtgrxb.plb @@prvtgri.plb --@@prvtgr.plb @@prvtgra.plb @@prvtgru.plb @@prvtgrlt.plb REM Address Parsing packages @@sdogcdrh.sql @@sdogcdrb.plb REM Spatial Routing Engine Files @@sdortprt.sql REM REM Network Manager PL/SQL Packages REM REM NDM LOD Spatial partition package @@sdopart.plb REM Network Manager Metadata Views @@sdonetmd.sql REM Network Manager Public PL/SQL Package Header @@sdoneth.sql REM Network Manager Private PL/SQL Package Header @@prvtneth.plb REM Network Manager Public PL/SQL Package Body @@sdonetb.plb REM Network Manager Private PL/SQL Package Body @@prvtnetb.plb REM NDM PL/SQL wrapper Package @@sdonetmemh.sql @@sdonetmemb.plb REM RDF upgrade and data migration @@sdosemdmh.sql @@sdosemdmb.plb REM RDF/OWL downgrade preparation package @@sdosemdgh.sql @@sdosemdgb.plb @@sdosemdgu.plb REM Spatial analysis/mining packages @@sdosam.sql @@prvtsam.plb REM dont install the foll two files REM New Commit Callback files REM @@sdoccbk.sql REM @@prvtccbk.plb