Export can only be run against a database that is fully open. DBV can be
run against any datafile, whether hot or cold, open, closed, or indifferent.
A full database export will check everything; DBV can be used to check just
a part of a data file (from block X to block Y). Export can't be applied to
objects owned by SYS. DBV can check the entire SYSTEM datafile. Export
can't check your backups, DBV can.
Regards
HJR
--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================
"Yong Huang" <yong321_at_yahoo.com> wrote in message
news:b3cb12d6.0110052003.5c08715d_at_posting.google.com...
> Jonathan,
>
> How do you compare using dbv and using exp to /dev/null to verify
> datafiles? One of them is more reliable than the other? Or one is
> recommended in such and such scenario while the other in another?
> Suppose the database is open and controlfiles, logfiles are known to
> be good.
>
> Yong Huang
> yong321_at_yahoo.com
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:<1002304053.22582.0.nnrp-14.9e984b29_at_news.demon.co.uk>...
> > I would go for a full database export to /dev/null.
> > This will physical verify all the user data, and
> > most of the data dictionary.
Received on Sat Oct 06 2001 - 00:07:05 CDT
