| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsdbv.sql |
| First Available |
10.1 |
| Dependencies |
None |
| Security Model |
Owned by SYS with no privileges granted |
| |
| 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); |
conn / as sysdba
col name format a30
col value format a30
SELECT name, value
FROM gv$parameter
WHERE name LIKE '%block%';
SELECT file_name, tablespace_name
FROM dba_data_files
ORDER BY 2,1;
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\uwdata01.dbf', 139, 96711, 8192, vOutput, vError, vStats);
dbms_output.put_line('Output: ' || vOutput);
dbms_output.put_line('Error: ' || vError);
dbms_output.put_line('Stats: ' || vStats);
END;
/ |
|
|
