eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

CTXSYS.DRIXMD dependencies on DR_DEF

Line 87: ) return dr_def.idx_rec;

83: FUNCTION GetIndexRec(
84: p_idx_name in varchar2,
85: f_ispolicy in number default POL_INDEX_ONLY,
86: f_security in number default SEC_CONTAINS
87: ) return dr_def.idx_rec;
88:
89: /*--------------------------- ImportingIndex ----------------------------*/
90: /* return true if the index name is in import state */
91: /* note: pass in simple name. owner is implied -SESSIONID */

Line 134: o_clause in out dr_def.vc500_tab

130:
131: PROCEDURE GetIndexStorage(
132: p_idxid in number,
133: p_ixpid in number,
134: o_clause in out dr_def.vc500_tab
135: );
136:
137: /*------------------------- GetIndexRecByID -----------------------------*/
138: /* get index meta data as a record */

Line 142: ) return dr_def.idx_rec;

138: /* get index meta data as a record */
139:
140: FUNCTION GetIndexRecByID(
141: p_idxid in number
142: ) return dr_def.idx_rec;
143:
144: /*---------------------------- GetPartitionRec ---------------------------*/
145: /* get partition meta data as a record */
146:

Line 149: p_idx in dr_def.idx_rec

145: /* get partition meta data as a record */
146:
147: FUNCTION GetPartitionRec(
148: p_ixp_name in varchar2,
149: p_idx in dr_def.idx_rec
150: ) return dr_def.ixp_rec;
151:
152: /*-------------------------- GetPartitionRecByID -------------------------*/
153: /* get partition meta data as a record */

Line 150: ) return dr_def.ixp_rec;

146:
147: FUNCTION GetPartitionRec(
148: p_ixp_name in varchar2,
149: p_idx in dr_def.idx_rec
150: ) return dr_def.ixp_rec;
151:
152: /*-------------------------- GetPartitionRecByID -------------------------*/
153: /* get partition meta data as a record */
154:

Line 158: ) return dr_def.ixp_rec;

154:
155: FUNCTION GetPartitionRecByID(
156: p_ixpid in number,
157: p_idxid in number
158: ) return dr_def.ixp_rec;
159:
160: /*---------------------------- GetPartitionID ---------------------------*/
161: /* get partition ID */
162:

Line 173: o_ids out nocopy dr_def.id_tab,

169: /* get all partition ids and names */
170:
171: procedure GetAllPartitionInfo(
172: p_idxid in number,
173: o_ids out nocopy dr_def.id_tab,
174: o_names out nocopy dr_def.vc30_tab
175: );
176:
177: /*---------------------------- GetAllPartitions ---------------------------*/

Line 174: o_names out nocopy dr_def.vc30_tab

170:
171: procedure GetAllPartitionInfo(
172: p_idxid in number,
173: o_ids out nocopy dr_def.id_tab,
174: o_names out nocopy dr_def.vc30_tab
175: );
176:
177: /*---------------------------- GetAllPartitions ---------------------------*/
178: /* get all partition metadata in a table */

Line 183: o_ixp in out nocopy dr_def.ixp_tab

179:
180: PROCEDURE GetAllPartitions(
181: p_idxid in number,
182: p_idxtab# in number,
183: o_ixp in out nocopy dr_def.ixp_tab
184: );
185:
186: /*---------------------------- GetIndexPartition -----------------------*/
187: /* get dr$index_partition information */

Line 230: o_objs in out nocopy dr_def.ixo_tab

226: /* get the index objects as a table */
227:
228: PROCEDURE GetAllIndexObjects(
229: p_idxid in number,
230: o_objs in out nocopy dr_def.ixo_tab
231: );
232:
233: /*---------------------------- NextIndexValue ----------------------------*/
234: /* get next dr$index_value cursor */

Line 402: PROCEDURE PurgeKGL(p_idx in dr_def.idx_rec);

398:
399: PROCEDURE PurgeKGL(p_idxid in number, ia sys.odciindexinfo,
400: isPart boolean default FALSE);
401:
402: PROCEDURE PurgeKGL(p_idx in dr_def.idx_rec);
403:
404: PROCEDURE PurgeKGL(p_idxid in number, owner in varchar2,
405: index_name in varchar2,
406: other_name in varchar2 default NULL);

Line 554: p_idxp in dr_def.idx_rec,

550: /* ensure that a global index and an index partition are compatible for */
551: /* exchange partition operation */
552:
553: PROCEDURE CheckIndexesForExchange(
554: p_idxp in dr_def.idx_rec,
555: p_idxn in dr_def.idx_rec
556: );
557:
558: /*--------------------------- ExchangeIndexMD ---------------------------*/

Line 555: p_idxn in dr_def.idx_rec

551: /* exchange partition operation */
552:
553: PROCEDURE CheckIndexesForExchange(
554: p_idxp in dr_def.idx_rec,
555: p_idxn in dr_def.idx_rec
556: );
557:
558: /*--------------------------- ExchangeIndexMD ---------------------------*/
559: /* exchange meta data */

Line 562: p_idxn in dr_def.idx_rec,

558: /*--------------------------- ExchangeIndexMD ---------------------------*/
559: /* exchange meta data */
560:
561: procedure ExchangeIndexMD(
562: p_idxn in dr_def.idx_rec,
563: p_idxpid in number,
564: p_ixpp in dr_def.ixp_rec
565: );
566:

Line 564: p_ixpp in dr_def.ixp_rec

560:
561: procedure ExchangeIndexMD(
562: p_idxn in dr_def.idx_rec,
563: p_idxpid in number,
564: p_ixpp in dr_def.ixp_rec
565: );
566:
567: /*--------------------------- RenameIndex -------------------------------*/
568: /* rename an index */

Line 589: o_ids out nocopy dr_def.id_tab

585: /* get all partition id's */
586:
587: procedure GetAllPartitionIDs(
588: p_idxid in number,
589: o_ids out nocopy dr_def.id_tab
590: );
591:
592: /*--------------------------- GetAllPartitionOPTs ------------------------*/
593: /* get all partition option's */

Line 597: o_opts out nocopy dr_def.vc256_tab

593: /* get all partition option's */
594:
595: procedure GetAllPartitionOPTs(
596: p_idxid in number,
597: o_opts out nocopy dr_def.vc256_tab
598: );
599:
600: /*--------------------------- GetAllPartitionNMs ------------------------*/
601: /* get all index partition names */

Line 605: o_names out nocopy dr_def.vc30_tab

601: /* get all index partition names */
602:
603: procedure GetAllPartitionNMs(
604: p_idxid in number,
605: o_names out nocopy dr_def.vc30_tab
606: );
607:
608: /*--------------------------- SetIndexMD --------------------------------*/
609: /* change a field of index meta-data */

Line 742: p_src in dr_def.idx_rec,

738: /*---------------------------- CopyIndexMDRIO ---------------------------*/
739: /* copy index meta-data for Recreate Index Online */
740:
741: PROCEDURE CopyIndexMDRIO(
742: p_src in dr_def.idx_rec,
743: p_dst in out nocopy dr_def.idx_rec,
744: p_create in boolean
745: );
746:

Line 743: p_dst in out nocopy dr_def.idx_rec,

739: /* copy index meta-data for Recreate Index Online */
740:
741: PROCEDURE CopyIndexMDRIO(
742: p_src in dr_def.idx_rec,
743: p_dst in out nocopy dr_def.idx_rec,
744: p_create in boolean
745: );
746:
747: PROCEDURE CopyPartMDRIO(

Line 748: ixp in dr_def.ixp_rec,

744: p_create in boolean
745: );
746:
747: PROCEDURE CopyPartMDRIO(
748: ixp in dr_def.ixp_rec,
749: idx in dr_def.idx_rec,
750: p_create in boolean
751: );
752:

Line 749: idx in dr_def.idx_rec,

745: );
746:
747: PROCEDURE CopyPartMDRIO(
748: ixp in dr_def.ixp_rec,
749: idx in dr_def.idx_rec,
750: p_create in boolean
751: );
752:
753: /*---------------------------- GetAllCDIColumns ---------------------------*/

Line 757: o_cdi in out nocopy dr_def.cdi_tab

753: /*---------------------------- GetAllCDIColumns ---------------------------*/
754:
755: PROCEDURE GetAllCDIColumns(
756: p_idxid in number,
757: o_cdi in out nocopy dr_def.cdi_tab
758: );
759:
760: /*---------------------------- UpdateSDATA ---------------------------*/
761:

Line 801: diffs in out dr_def.ixv_tab

797: procedure CompareIndexObjectValuesPref(
798: p_idxid in number,
799: p_pref in varchar2,
800: p_cla_id in number,
801: diffs in out dr_def.ixv_tab
802: );
803:
804: /*--------------------------- RemoveStageItab ------------------------------*/
805: /* remove stage_itab from dr$index_value without modifying storage pref */

Line 841: function check_auto_optimize(p_idx in dr_def.idx_rec,

837: CheckAutoOptimizeRunning constant number := 2;
838: CheckAutoOptimizeNotReg constant number := 3;
839: CheckAutoOptimizeConcOpt constant number := 4;
840:
841: function check_auto_optimize(p_idx in dr_def.idx_rec,
842: p_ixp in dr_def.ixp_rec,
843: p_override in boolean default false)
844: return number;
845:

Line 842: p_ixp in dr_def.ixp_rec,

838: CheckAutoOptimizeNotReg constant number := 3;
839: CheckAutoOptimizeConcOpt constant number := 4;
840:
841: function check_auto_optimize(p_idx in dr_def.idx_rec,
842: p_ixp in dr_def.ixp_rec,
843: p_override in boolean default false)
844: return number;
845:
846: /*--------------------------- start_auto_optimize --------------------------*/

Line 860: procedure add_auto_optimize(p_idx in dr_def.idx_rec,

856: procedure run_auto_optimize;
857:
858: /*--------------------------- add_auto_optimize ----------------------------*/
859: /* add an auto optimize index / partition */
860: procedure add_auto_optimize(p_idx in dr_def.idx_rec,
861: p_ixp in dr_def.ixp_rec);
862:
863: /*--------------------------- remove_auto_optimize -------------------------*/
864: /* remove an auto optimize index / partition */

Line 861: p_ixp in dr_def.ixp_rec);

857:
858: /*--------------------------- add_auto_optimize ----------------------------*/
859: /* add an auto optimize index / partition */
860: procedure add_auto_optimize(p_idx in dr_def.idx_rec,
861: p_ixp in dr_def.ixp_rec);
862:
863: /*--------------------------- remove_auto_optimize -------------------------*/
864: /* remove an auto optimize index / partition */
865: procedure remove_auto_optimize(p_idxid in number,

Line 917: sdata_secs in out dr_def.sec_tab

913: FUNCTION isSES return boolean;
914:
915: PROCEDURE GetAllSDATASecs(
916: idxid in number,
917: sdata_secs in out dr_def.sec_tab
918: );
919:
920: /*--------------------------- partid_to_partname -----------------------*/
921: /* Fetch partition name, given partition id and index id */