| 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;
/ |
|
|
