$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << 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
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>