Oracle DBMS_DBVERIFY DBV


	CODE Oracle Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

Search the Reference Library pages:

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_DBVERIFY

Version 11.1

General Information

Source

{ORACLE_HOME}/rdbms/admin/dbmsdbv.sql

First Available

10.1

Dependencies

DBMS_DBV_LIB

Object Privileges

execute on dbms_dbverify

GRANT execute ON dbms_dbverify TO UWCLASS;

DBV2

Verify data file integrity

Note: Any information on how to interpret the output will be greatly appreciated.

dbms_dbverify.dbv2(
fname     IN     VARCHAR2,
start_blk IN     BINARY_INTEGER,
end_blk   IN     BINARY_INTEGER,
blocksize IN     BINARY_INTEGER,
output    IN OUT VARCHAR2,
error     IN OUT VARCHAR2,
stats     IN OUT VARCHAR2);

Note: This demo worked in 10gR1 ... fails in 10gR2 with:

dbms_dbverify.dbv2('c:\oracle\product\oradata\orabase\UWDATA1.DBF');
*
ERROR at line 6:
ORA-06550: line 6, column 1:
PLS-00201: identifier 'DBMS_DBVERIFY.DBV2' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored

conn / as sysdba

col name format a30
col value format a30
SELECT name, value
FROM gv$parameter
WHERE name LIKE '%block%';

SELECT owner, table_name
FROM dba_tables
WHERE tablespace_name = 'UWDATA';

SELECT MIN(dbms_rowid.rowid_block_number(rowid))
FROM uwclass.airplanes;

SELECT MAX(dbms_rowid.rowid_block_number(rowid))
FROM uwclass.airplanes;

set serveroutput on

DECLARE
vOutput VARCHAR2(4000) := '';
vError VARCHAR2(4000) := '';
vStats VARCHAR2(4000) := '';
BEGIN
dbms_dbverify.dbv2('c:\oracle\product\oradata\orabase\UWDATA1.DBF', 13, 14, 8192, vOutput, vError, vStats);

dbms_output.put_line('Output: ' || vOutput);
dbms_output.put_line('Error: ' || vError);
dbms_output.put_line('Stats: ' || vStats);
END;
/

Related Topics

DBV

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us