Re: Import from compressed dump failing because of long columns

James Keane wrote:
>
> I am trying to restore from backup after a severe database disk crash,
> but am failing on the largest table (& most important, of course) in
> the backup. The error is
>
> IMP-00020: long column too large for column buffer size (100)
>
> Per the newsgroups I have already upped the buffer size and record
> size, but to no avail. I cannot go back and create another backup as
> the old database is now toast.
>
> This backup was created using a "pipe" through gzip. I am using the
> reverse to import it, and have been able to partial restores before,
> but never full restores.
>

[]
>
> As this is a production database we are in quite a bind here. Anything
> you can suggest would be much appreciated.
>
> Cheers,
> James

Let this be a reminder to others to test their restore process BEFORE they need it. I know that doesn't help you, James, but as a friend in another news group said:

you can always be a good example of a bad example.

Good luck. Received on Mon Dec 02 2002 - 15:55:05 CST