Re: Tools to verify Oracle exports and offline backups

If the export is not big, you could try doing an import with ROWS=N and INDEXFILE=filename. It won't import anything, but will write the code to create the tables and indexes into "filename". Doen't verfy all objects, but will cause the dmp file to be read.

jboehler_at_my-deja.com wrote:

> What are some reliable methods to validate the integrity of Oracle
> 7.3.4 exports and off line backups?
> We have tried using DB_VERIFY (dbverf73.exe) but have heard this is not
> adequate to verify offline backups.
> For exports we have used IMPORT with the show option.
> Are there other tools to validate the integrity of exports or off line
> backups?
>
> Thanx,
> Jeff Boehlert
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--

/* julian hare:
 *
 * julianh_at_eagles.bbs.net.au
 *
 */