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 <short description of component this file declares/defines>
Rem
Rem NOTES
Rem <other useful comments, qualifications, etc.>
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