Edit D:\app\Administrator\product\11.2.0\dbhome_1\ctx\admin\ctxu1120.sql
Rem Rem $Header: ctxu1120.sql 07-jun-2008.12:14:16 rpalakod Exp $ Rem Rem ctxu1120.sql Rem Rem Copyright (c) 2008, Oracle. All rights reserved. Rem Rem NAME Rem ctxu1120.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem upgrade from 11.2.0.0 to latest version Rem Rem NOTES Rem <other useful comments, qualifications, etc.> Rem Rem MODIFIED (MM/DD/YY) Rem rpalakod 06/07/08 - 11.2 Rem rpalakod 06/07/08 - Created Rem REM ======================================================================== REM set schema, Registry to upgrading state REM ======================================================================== ALTER SESSION SET CURRENT_SCHEMA = CTXSYS; begin dbms_registry.upgrading('CONTEXT','Oracle Text','validate_context','CTXSYS'); end; / REM ======================================================================== REM REM ******************* Begin SYS changes ********************************** REM REM ======================================================================== ALTER SESSION SET CURRENT_SCHEMA = SYS; @@s1102000.sql ALTER SESSION SET CURRENT_SCHEMA = CTXSYS; REM ======================================================================== REM REM ******************* End SYS changes ************************************ REM REM ======================================================================== REM ======================================================================== REM REM ******************* Begin CTXSYS schema changes ************************ REM REM ======================================================================== REM ======================================================================== REM Pre-upgrade steps REM ======================================================================== @@ctxpreup.sql REM ======================================================================== REM 11.2 to next version REM ======================================================================== @@u1102000.sql @@t1102000.sql REM ======================================================================== REM Post-upgrade steps REM ======================================================================== @@ctxposup.sql ALTER SESSION SET CURRENT_SCHEMA = CTXSYS; REM ======================================================================== REM REM **************** End CTXSYS schema change ***************************** REM REM ======================================================================== REM ======================================================================== REM Registry to upgraded state, reset schema REM ======================================================================== begin dbms_registry.loaded('CONTEXT'); dbms_registry.valid('CONTEXT'); end; / ALTER SESSION SET CURRENT_SCHEMA = SYS;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de