Chapter 45. DBMS_VERIFY
Prev   Next

Chapter 45. DBMS_VERIFY

Table of Contents

45.1. Overview
45.2. Procedures
45.2.1. SCHEMA_INDEX
45.2.2. TABLE_INDEX
45.2.3. INDEX

This chapter briefly introduces the DBMS_VERIFY package, and describes how to use the procedures and functions of the package.

45.1. Overview

DBMS_VERIFY checks integrity of various items.

45.2. Procedures

This section describes the procedures provided by the DBMS_VERIFY package, in alphabetical order.

45.2.1. SCHEMA_INDEX

Checks integrity of all indexes in the specified schema.

Details about the SCHEMA_INDEX procedure are as follows:

  • Prototype

    DBMS_VERIFY.SCHEMA_INDEX
(
    SCHEMA           IN              VARCHAR2,
    DOP              IN              NUMBER DEFAULT 0
);

  • Parameter

    ParameterDescription
    SCHEMASchema name of the index to check integrity for.
    DOPDegree Of Parallelism.

  • Example

    declare
    schema varchar2(1024);
begin
    schema := 'TIBERO';
    DBMS_VERIFY.SCHEMA_INDEX(schema);
end;
/

45.2.2. TABLE_INDEX

Checks integrity of all indexes in the specified table.

Details about the TABLE_INDEX procedure are as follows:

  • Prototype

    DBMS_VERIFY.TABLE_INDEX
(
    SCHEMA           IN             VARCHAR2,
    TBLNAME          IN             VARCHAR2,
    DOP              IN             NUMBER DEFAULT 0
);

  • Parameter

    ParameterDescription
    SCHEMASchema name of the indexes to check integrity for.
    TBLNAMETable name of the indexes to check integrity for.
    DOPDegree Of Parallelism.

  • Example

    declare
    schema varchar2(1024);
    tblname varchar2(1024);
begin
    schema := 'TIBERO';
    tblname := 'TT';
    DBMS_VERIFY.TABLE_INDEX(schema, tblname);
end;
/

45.2.3. INDEX

Compares the number of rows found by using an index and by scanning a table for index integrity checking.

Details about the INDEX procedure are as follows:

  • Prototype

    DBMS_VERIFY.INDEX
(
    SCHEMA          IN              VARCHAR2,
    TBLNAME         IN              VARCHAR2,
    IDXNAME         IN              VARCHAR2,
    DOP             IN              NUMBER DEFAULT 0
);

  • Parameter

    ParameterDescription
    SCHEMASchema name of the index to check integrity for.
    TBLNAMETable name of the index to check integrity for.
    IDXNAMEIndex name to check integrity for.
    DOPDegree Of Parallelism.

  • Example

    declare
    schema varchar2(1024);
    tblname varchar2(1024); 
    idxname varchar2(1024);
begin
    schema := 'TIBERO';
    tblname := 'TT';
    idxname := 'TT_IDX';

    DBMS_VERIFY.INDEX(schema, tblname, idxname);
end;
/
Prev   Next
Chapter 44. DBMS_UTILITY Home Chapter 46. DBMS_XMLDOM