Script to generate dbverify for all datafiles.



Script to generate dbverify for all datafiles.


set head off
set lines 200
set feedback off
set define off
spool dbv.sh

select 'dbv file='||name||' blocksize= '||block_size|| ' LOGFILE=FILE-'||FILE#||'.LOG' from v$datafile;
spool off


 

Comments