19 septiembre 2006

Check dmp file generated

To check if a backup made ​​with the export utility is reliable we can use the
INDEXFILE parameter, which generates a file with the definitions of tables and indexes in a file. Do not worry, this parameter is not "load" information to the database:

Once done the backup with the export utility, we can test it with the import command.

imp system/passwd file=expfull.dmp log=testdmp.log fromuser=fulano touser=fulano tables=tablita indexfile=archivodat.txt

This way we can verify that the file expfull.dmp is in good condition.

The file contains the definitions archivodat.txt creating Tables and indexes.

The INDEXFILE parameter can only be used with FULL = Y, FROMUSER,TOUSER, TABLES parameters.

No hay comentarios.: