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

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

Rem
Rem Copyright (c) 1998, 2008, Oracle and/or its affiliates. All rights reserved.
Rem  NAME
Rem    drvparx.pkh - DR cartridge PARallel indeX services
Rem  DESCRIPTION
rem
Rem  RETURNS
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
REm     surman     01/03/07  - 5738539: Change to index owner for parallel sync
REm     ehuang     10/24/03  - tracing 
REm     gkaminag   03/06/03  - switch user on opt if needed
REm     smuralid   12/20/02  - PX support
REm     smuralid   12/03/02  - add drvparx package
REm     gkaminag   07/02/02  - gkaminag_misc_020702
REm     gkaminag   06/01/02 -  migrate from driddlp
Rem     yucheng    10/12/01 -  parallel sync
Rem     yucheng    09/26/01 -  parallel support
Rem     yucheng    08/23/01 -  creation

create or replace package drvparx authid current_user is
   FUNCTION ParallelPopuIndex(
     cur        SYS_REFCURSOR, 
     idxownid   number,
     idxid      number,
     idxo       varchar2, 
     idxn       varchar2,
     idxp       varchar2,
     idxpopstate dr$popindex_state_t) 
       return sys.odcivarchar2list
      parallel_enable(partition cur by any) pipelined;

FUNCTION IndexOptimizeParFn(
     crsr        in drvddl.popcurtyp,
     idxownid    in number,
     idxowner    in varchar2,
     idxname     in varchar2,
     ixpname     in varchar2,
     shadow_itab in varchar2,
     nextid     in number,
     shadow_ntab in varchar2,
     optstate    in dr$optim_state_t
   ) return sys.odcivarchar2list
     pipelined parallel_enable (partition crsr BY HASH(num));

FUNCTION TraceGetTrace return dr$trc_tab;

end drvparx;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de