Thursday, February 5, 2009

import a single table from full schema dumps

Yesterday i had a problem with production database, our cron based script made the import of wrong dumps of a table, so we were having problem with only this table.

We did't had any other solution to revert these changes, so we went to import this table from latest dumps, here is the script i use to do so:

imp system tables=TABLE_NAME \
fromuser=USER_NAME \
touser=USER_NAME \
file=/path-to-directory/dump-file-name.dmp \
log=/path-to-directory/log-file-name.log \
resumable=y \
commit=n \
resumable_timeout=3600 \
ignore=y \
constraints=n


cheers