Edit D:\app\Administrator\product\11.2.0\dbhome_1\ctx\admin\ctxe102.sql
Rem Rem $Header: ctxe102.sql 28-sep-2007.10:29:07 wclin Exp $ Rem Rem ctxe102.sql Rem Rem Copyright (c) 2005, 2007, Oracle. All rights reserved. Rem Rem NAME Rem ctxe102.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem downgrade from 11.x to 10.2 Rem Rem NOTES Rem <other useful comments, qualifications, etc.> Rem Rem MODIFIED (MM/DD/YY) Rem wclin 09/28/07 - add call to d1100000.sql Rem oshiowat 09/15/05 - feature usage tracking Rem gkaminag 09/01/05 - drop packages Rem yucheng 06/24/05 - yucheng_bug-3003812 Rem yucheng 06/23/05 - Created Rem REM =========================================================== REM revoke select privilege on SYS.GV_$DB_OBJECT_CACHE REM =========================================================== revoke select on SYS.GV_$DB_OBJECT_CACHE from CTXSYS; REM =========================================================== REM revoke select privilege on sys.snap$ REM =========================================================== revoke select on SYS.SNAP$ from CTXSYS; REM =========================================================== REM set schema, registry REM =========================================================== ALTER SESSION SET CURRENT_SCHEMA = CTXSYS; EXECUTE dbms_registry.downgrading('CONTEXT'); REM drop all packages, procedures, programmatic types @@ctxdpkg.sql REM run downgrade scripts @@d1100000.sql @@d1002000.sql REM ======================================================================== REM Registry to downgraded state REM ======================================================================== EXECUTE dbms_registry.downgraded('CONTEXT','10.2.0'); REM ======================================================================== REM reset schema to SYS REM ======================================================================== ALTER SESSION SET CURRENT_SCHEMA = SYS;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de