Re: [Info-ingres] Transaction log size (was Huge copy out/in)

I haven't followed this thread too closely, but here's an 'outside the box'
suggestion..

Instead of trying this unload/reload as a single hit, would it help to do an
ascii unload then use a script to divide up the data into smaller files
(this is quite easy)? You could then run a batch of copy.in scripts to
reload the smaller unloads back into a single table. This would avoid the
limits problem you may be hitting and stop your problems of filling the
transaction log.

You could even, at a pinch reload the smaller data files into different
tables and then (using SQL) insert them back into the main table after
loading - that way you could run the copy.in scripts simultaneously.

I'd even suggest slicing up a binary unload, but I think it might be too
dangerous..

Apologies for the belt and braces suggestion - kinda the way I approach
stuff..

Paul


.

Relevant Pages

  • Re: Pop3 Problem
    ... > After reading some of the other posts I found a suggestion to unload ... Glad it's resolved - thanks for posting back (& thanks for searching/doing ...
    (microsoft.public.outlook)
  • RE: Make APP.EXE disabled
    ... In addition to Ralph's suggestion, I think you may try to unload all the ... addin and restart the vb to see if that helps. ...
    (microsoft.public.vb.bugs)
  • Re: populate a list box with different data
    ... You had several userforms, each loading ... Unload Me ... I tried to explain why each successive form unload / load would inevitably ... > I WAS NOT IGNORING THE SUGGESTION IT WAS THAT THE WAY I WAS DOING IT ...
    (microsoft.public.excel.programming)
  • Re: a question~~ thx
    ... if I do not using the form, can you give me some suggestion? ... >> unload itself ... >> what is the matter? ... >> thx~ ...
    (microsoft.public.vb.general.discussion)
  • RE: [Info-ingres] Transaction log size (was Huge copy out/in)
    ... You can do multiple 'fast copies' aka 'bulk loads' in to a HEAP table ... Transaction log size ... The Binary unload went to the end. ... loading - that way you could run the copy.in scripts simultaneously. ...
    (comp.databases.ingres)