Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\ctx\admin\dririo.pkh

Rem 
rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
rem    NAME
rem      dririo.pkh
rem    DESCRIPTION
rem      This package contains functions for ctx_ddl.recreate_index_online
rem
rem    NOTES
rem    MODIFIED    (MM/DD/YY)
rem      yucheng    01/11/06  - recreate index online partition 
rem      yucheng    10/18/05  - recreate_index online 
rem      gkaminag   08/24/05  - gkaminag_recreate_online_phase1
rem      gkaminag   08/22/05  - creation

create or replace package dririo as

LOCK_WAIT     constant number := null;
  LOCK_NOWAIT   constant number := 0;
  IGNORE_ERRORS constant boolean := TRUE;

/*------------------------------ lock_rio --------------------------------*/

procedure lock_rio(
  cid        in number,
  pid        in number,
  timeout    in number
);

/*----------------------------- unlock_rio ------------------------------*/

procedure unlock_rio(
  ignore_errors in boolean default false
);

/*----------------------------- shadow_name ------------------------------*/
/* return the name of the shadow policy, given source policy id */

function shadow_name(
  idx_id in number,
  ixp_id in number default null
) return varchar2;

/*------------------------- lock_rio_all_part ----------------------------*/

procedure lock_rio_all_part(
  cid        in number
);

/*------------------------ unlock_rio_all_part ---------------------------*/

procedure unlock_rio_all_part(
  ignore_errors in boolean default false
);

procedure create_shadow(
  idx        dr_def.idx_rec,
  idx_shadow in out nocopy dr_def.idx_rec
);

procedure create_shadow_partMD(
   idx         dr_def.idx_rec,
   ixp_id      number
);

end dririo;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de