Edit D:\app\Administrator\product\11.2.0\dbhome_1\md\admin\sdomigj.sql
Rem Rem $Header: sdo/admin/sdomigj.sql /main/8 2009/04/06 10:48:38 jcwang Exp $ Rem Rem sdomigj.sql Rem Rem Copyright (c) 2006, 2009, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem sdomigj.sql - <one-line expansion of the name> 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 jcwang 04/03/09 - 11.2 NDM upgrade dif Rem hgong 04/01/09 - drop md/lib/sdonm.jar Rem sravada 10/20/08 - add explicit drops back Rem hgong 09/18/08 - drop md/jlib/sdonm.jar Rem zzhang 02/20/08 - Rem sravada 11/01/06 - Created Rem --drop NDM related class files alter session set current_schema=SYS; call dbms_java.grant_permission('SYSTEM', 'java.io.FilePermission', '<<ALL FILES>>', 'read'); call dbms_java.grant_permission('MDSYS', 'SYS:java.io.FilePermission', 'md/jlib/*', 'read'); call dbms_java.grant_permission('MDSYS', 'SYS:java.lang.RuntimePermission', 'getClassLoader', null); call dbms_java.grant_permission('ORDSYS', 'SYS:java.lang.RuntimePermission', 'getClassLoader', null); -- explicitly drop some of the NDM classes call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/XMLAdapter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/XMLAdapter$1'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/XMLAdapter$DatabaseMetadata'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/LinkTypeConstraint'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/lod/Dijkstra$VisitedNode'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/lod/LODAnalysisInfoImpl'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/lod/NetworkExplorer$NodeInfo'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/lod/NetworkExplorer$PointOnLink'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/network/RandomGraph'); call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdonm.jar'); call dbms_java.dropjava('-force -synonym -schema MDSYS md/lib/sdonm.jar'); call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdogcdr.jar'); call dbms_java.dropjava('-force -synonym -schema MDSYS md/lib/sdogcdr.jar'); call dbms_java.dropjava('-force -synonym -schema MDSYS md/jlib/sdoutl.jar'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/util/RTree$1'); --drop georaster related classes call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/BLOBWriter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/BMPWriter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/GeoRasterAdapter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/GeoRasterGeoTIFFInterface'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/GeoRasterProcessUtil'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JGeoRasterSRS'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JP2Writer'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JPEGWriter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/PNGWriter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/TIFFWriter'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/RationalFunction'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/Polynomial'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JRaster'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JGeoRasterMeta'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JGeoRaster'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/GeoRasterException'); call dbms_java.dropjava('-force -synonym -schema MDSYS oracle/spatial/georaster/JGeoRasterMeta$BandInfo'); call dbms_java.revoke_permission('MDSYS','SYS:java.io.FilePermission', 'md/jlib/*','read'); commit; alter session set current_schema=MDSYS;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de