Edit D:\app\Administrator\product\11.2.0\dbhome_1\ctx\admin\ctxu1010.sql
Rem Rem $Header: ctxu1010.sql 07-jun-2008.12:19:03 rpalakod Exp $ Rem Rem ctxu1010.sql Rem Rem Copyright (c) 2004, 2008, Oracle. All rights reserved. Rem Rem NAME Rem ctxu1010.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem upgrade from 10.1 to 10.2 Rem Rem NOTES Rem <other useful comments, qualifications, etc.> Rem Rem MODIFIED (MM/DD/YY) Rem rpalakod 06/07/08 - 11.2 Rem yucheng 06/22/05 - load 10.2 upgrade scripts Rem gkaminag 10/07/04 - val proc to sys Rem gkaminag 03/22/04 - gkaminag_misc_040318 Rem gkaminag 03/18/04 - Created Rem Rem ======================================================================= Rem Rem ******************** changes to be made by SYS ************************ Rem Rem ======================================================================= @@s1001002.sql @@s1002000.sql Rem ======================================================================= Rem Rem *********************** end of SYS changes ************************* Rem 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 CTXSYS schema changes ************************ REM REM ======================================================================== REM ======================================================================== REM Pre-upgrade steps REM ======================================================================== @@ctxpreup.sql REM ======================================================================== REM 10.1 to 10.2 REM ======================================================================== @@u1001002.sql @@t1001002.sql REM ======================================================================== REM 10.2 to 11.1.0 REM ======================================================================== @@u1002000.sql @@t1002000.sql REM ======================================================================== REM 11.1.0 to 11.2.0 REM ======================================================================== @@u1100000.sql @@t1100000.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