CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 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 [145 users online]    © 2010 psoug.org