Re: Restarting a dbimport
Posted in 1997
Topics: Security, Permissions & Auditing, Migration, Import/Export & Data Conversion
In article <65rn0t$e56@newsserv.cs.sunysb.edu>, trubisz@cs.sunysb.edu (Joe
Trubisz) wrote:
> Hi...
>
> I had a dbimport fail after 12h because the dbimport exported
> 2-tables with the same name, but different owners. Dbexport
> apparently didn't like that. Unfortunately, it happened almost
> at the end of the script. Without rerunning the whole thing
> all over again, is there a way to just 'pick up' where it left
> off, after the offending part of the script is removed?
>
> Thanks in advance.
>
>
> Joe
Nowadays I don't use dbimport. I used to use it on V5.x until I frequently
encountered some strange errors about column mismatch etc.
I put together some simple scripts to break the dbexport sql file into
smaller sql files that create tables, load data, grant privileges, create
views, and create indexes. That way I just need to work on those loads
that fail.
Rgds
Alvin
--
Alvin Koh
Email: AlvinKoh@WriteMe.COM