Re: Need to restore from dump

If you've added a column to the table you will not need to drop the table to import the old data. Simply import using the ignore=y option:

imp user/pass file=<file.dmp> full=y ignore=y

This is presuming that the only table in the dump file is the one in question. If there is more than one table in the dump file:

imp user/pass file=<file.dmp> tables=<your table here> ignore=y

Of course, your new column will be null for all records, but as long as that is allowed imp should not complain about the new column being there.

I frankly don't understand why you truncated the table just to add a new column; such action was entirely unnecessary.

norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0204101555.27d38f7a_at_posting.google.com>...
> Yes. Just drop the table, and re-import. You wont have the new
> column, but it is a start.
Received on Thu Apr 11 2002 - 11:22:03 CDT