342: section_name section name
343: */
344: PROCEDURE IndexReplace(
345: ia in sys.ODCIIndexInfo,
346: idx in out nocopy dr_def.idx_rec,
347: idxmem in number,
348: para in number,
349: langcol in varchar2,
350: fmtcol in varchar2,
386: para parallel degree
387: */
388: PROCEDURE IndexPartReplace(
389: ia in sys.ODCIIndexInfo,
390: idx in dr_def.idx_rec,
391: ixp in dr_def.ixp_rec,
392: idxmem in number,
393: storage in varchar2,
394: para in number,
387: */
388: PROCEDURE IndexPartReplace(
389: ia in sys.ODCIIndexInfo,
390: idx in dr_def.idx_rec,
391: ixp in dr_def.ixp_rec,
392: idxmem in number,
393: storage in varchar2,
394: para in number,
395: sync_type in varchar2,
419: isreplace called from replace
420: */
421: PROCEDURE IndexResume(
422: ia in sys.ODCIIndexInfo,
423: idx in dr_def.idx_rec,
424: para in number,
425: idxmem in number,
426: isonline in boolean default FALSE,
427: isreplace in boolean default FALSE,
443: idxmem index memory
444: */
445: PROCEDURE IndexPartResume(
446: ia in sys.ODCIIndexInfo,
447: idx in dr_def.idx_rec,
448: para in number,
449: idxmem in number,
450: isOnline in boolean default FALSE,
451: isReplace in boolean default FALSE,
467: maxtime maxtime for gc
468: token text token string
469: */
470: PROCEDURE IndexOptimize(
471: idx in dr_def.idx_rec,
472: ixpname in varchar2,
473: operation in varchar2,
474: maxtime in number,
475: token in varchar2,
519: mapping tables will be created (for cleanup
520: purposes in case of core dump)
521: */
522: PROCEDURE SplitDollari(
523: idx in dr_def.idx_rec,
524: ixpname in varchar2,
525: mapping_tab in varchar2,
526: name_prefix in varchar2,
527: tspace in varchar2 default null
541: ixpname index partition name
542: direct_path should we use direct-path inserts ?
543: */
544: PROCEDURE IndexSync(
545: idx in dr_def.idx_rec,
546: ixpname in varchar2,
547: idxmem in number,
548: parallel_degree in number default 1,
549: direct_path in boolean default false,
594: newvallist in sys.odcicolarrayvallist
595: );
596:
597: PROCEDURE RIOCleanup(
598: idx_shadow in dr_def.idx_rec
599: );
600:
601: PROCEDURE PartCleanup(
602: idx_shadow dr_def.idx_rec,
598: idx_shadow in dr_def.idx_rec
599: );
600:
601: PROCEDURE PartCleanup(
602: idx_shadow dr_def.idx_rec,
603: ixp_shadow dr_def.ixp_rec
604: );
605:
606: FUNCTION CursorToBitVector(
599: );
600:
601: PROCEDURE PartCleanup(
602: idx_shadow dr_def.idx_rec,
603: ixp_shadow dr_def.ixp_rec
604: );
605:
606: FUNCTION CursorToBitVector(
607: crsr in popcurtyp,
607: crsr in popcurtyp,
608: numbits in number) RETURN varchar2;
609:
610: PROCEDURE add_big_io(
611: idx in dr_def.idx_rec
612: );
613:
614: PROCEDURE remove_big_io(
615: idx in dr_def.idx_rec
611: idx in dr_def.idx_rec
612: );
613:
614: PROCEDURE remove_big_io(
615: idx in dr_def.idx_rec
616: );
617:
618: PROCEDURE add_separate_offsets(
619: idx in dr_def.idx_rec
615: idx in dr_def.idx_rec
616: );
617:
618: PROCEDURE add_separate_offsets(
619: idx in dr_def.idx_rec
620: );
621:
622: PROCEDURE add_stage_itab(
623: idx in dr_def.idx_rec,
619: idx in dr_def.idx_rec
620: );
621:
622: PROCEDURE add_stage_itab(
623: idx in dr_def.idx_rec,
624: ixp in dr_def.ixp_rec default NULL
625: );
626:
627: PROCEDURE remove_stage_itab(
620: );
621:
622: PROCEDURE add_stage_itab(
623: idx in dr_def.idx_rec,
624: ixp in dr_def.ixp_rec default NULL
625: );
626:
627: PROCEDURE remove_stage_itab(
628: idx in dr_def.idx_rec,
624: ixp in dr_def.ixp_rec default NULL
625: );
626:
627: PROCEDURE remove_stage_itab(
628: idx in dr_def.idx_rec,
629: ixp in dr_def.ixp_rec default NULL
630: );
631:
632: /*--------------------------- field_to_mdata -------------------------------*/
625: );
626:
627: PROCEDURE remove_stage_itab(
628: idx in dr_def.idx_rec,
629: ixp in dr_def.ixp_rec default NULL
630: );
631:
632: /*--------------------------- field_to_mdata -------------------------------*/
633: /* convert a field section to mdata */
631:
632: /*--------------------------- field_to_mdata -------------------------------*/
633: /* convert a field section to mdata */
634: PROCEDURE field_to_mdata(
635: idx in dr_def.idx_rec,
636: fsec in varchar2,
637: read_only in boolean
638: );
639:
639:
640: /*------------------------ IndexMapLanguagesDriver -------------------------*/
641: /* Driver for IndexMapLanguages - partitioned and non partitioned case. */
642: procedure IndexMapLanguagesDriver(
643: idx in dr_def.idx_rec
644: );
645:
646: /*--------------------------- IndexMapLanguages ---------------------------*/
647: /* Map language column in base table to mdata sections */
645:
646: /*--------------------------- IndexMapLanguages ---------------------------*/
647: /* Map language column in base table to mdata sections */
648: procedure IndexMapLanguages(
649: idx in dr_def.idx_rec,
650: ixp in dr_def.ixp_rec,
651: pdegree in number,
652: flags in binary_integer,
653: sectyp in binary_integer,
646: /*--------------------------- IndexMapLanguages ---------------------------*/
647: /* Map language column in base table to mdata sections */
648: procedure IndexMapLanguages(
649: idx in dr_def.idx_rec,
650: ixp in dr_def.ixp_rec,
651: pdegree in number,
652: flags in binary_integer,
653: sectyp in binary_integer,
654: hash_usable in number
657: /*---------------------- AddDocLexerMDATATokens ------------------------*/
658: /* Add DR$ML MDATA Tokens to $I */
659: PROCEDURE AddDocLexerMDATATokens(
660: ia in sys.ODCIIndexInfo,
661: idx in dr_def.idx_rec
662: );
663:
664: /*---------------------- RemDocLexerMDATATokens ------------------------*/
665: /* Remove DR$ML MDATA Tokens from $I(s) */
664: /*---------------------- RemDocLexerMDATATokens ------------------------*/
665: /* Remove DR$ML MDATA Tokens from $I(s) */
666: PROCEDURE RemDocLexerMDATATokens(
667: ia in sys.ODCIIndexInfo,
668: idx in dr_def.idx_rec
669: );
670:
671: /*--------------------------- idx_add_slx ------------------------------*/
672: /* Add sublexer to the Index */
671: /*--------------------------- idx_add_slx ------------------------------*/
672: /* Add sublexer to the Index */
673: PROCEDURE idx_add_slx(
674: ia in sys.ODCIIndexInfo,
675: idx in dr_def.idx_rec,
676: sub_lexer in varchar2,
677: language in varchar2,
678: alt_value in varchar2,
679: language_dependent in boolean default TRUE
682: /*--------------------------- idx_rem_slx ------------------------------*/
683: /* Remove sublexer from the Index */
684: PROCEDURE idx_rem_slx(
685: ia in sys.ODCIIndexInfo,
686: idx in dr_def.idx_rec,
687: sub_lexer in varchar2
688: );
689:
690: /*--------------------------- idx_add_sw ------------------------------*/
690: /*--------------------------- idx_add_sw ------------------------------*/
691: /* Add stopword to the Index */
692: PROCEDURE idx_add_sw(
693: ia in sys.ODCIIndexInfo,
694: idx in dr_def.idx_rec,
695: stopword in varchar2,
696: language in varchar2,
697: language_dependent in boolean default TRUE,
698: secname in varchar2
701: /*--------------------------- idx_rem_sw ------------------------------*/
702: /* Remove stopword from the Index */
703: PROCEDURE idx_rem_sw(
704: ia in sys.ODCIIndexInfo,
705: idx in dr_def.idx_rec,
706: stopword in varchar2,
707: language in varchar2,
708: for_all in boolean default FALSE
709: );
710:
711: /*--------------------------- repopulate_dollarn ---------------------------*/
712: /* repopulate_dollarn - repopulate $N as opposite of $K */
713: PROCEDURE repopulate_dollarn(
714: idx in dr_def.idx_rec,
715: ixp in dr_def.ixp_rec
716: );
717:
718: /*------------------------------ set_read_mode -----------------------------*/
711: /*--------------------------- repopulate_dollarn ---------------------------*/
712: /* repopulate_dollarn - repopulate $N as opposite of $K */
713: PROCEDURE repopulate_dollarn(
714: idx in dr_def.idx_rec,
715: ixp in dr_def.ixp_rec
716: );
717:
718: /*------------------------------ set_read_mode -----------------------------*/
719: /* set_read_mode - Set read mode to TRUE/FALSE, for given partition */
718: /*------------------------------ set_read_mode -----------------------------*/
719: /* set_read_mode - Set read mode to TRUE/FALSE, for given partition */
720: PROCEDURE set_read_mode(
721: ia in sys.ODCIIndexInfo,
722: idx in dr_def.idx_rec,
723: ixp in dr_def.ixp_rec default NULL,
724: read_mode in boolean
725: );
726:
719: /* set_read_mode - Set read mode to TRUE/FALSE, for given partition */
720: PROCEDURE set_read_mode(
721: ia in sys.ODCIIndexInfo,
722: idx in dr_def.idx_rec,
723: ixp in dr_def.ixp_rec default NULL,
724: read_mode in boolean
725: );
726:
727: end drvddl;