G'day,
At 6:48 PM -0600 29/7/01, Nelson Goforth wrote:
>just an overall table size (order of 4 Gb). I did try breaking it
>down into smaller chunks (copying and pasting), but may have to use
>ALTER as you suggest.
Why not use one of the *many* GUI admin/query tools available. They
are much easier to use than the command line.
But if you want to stick with the command line, try copying/pasting
even smaller chunks a time (that worked when I had exact same
problem) or try drag & drop (if your editor support dragging text).
Charlie
PS. My current favorite admin tool is SQLGrinder. My previous
favorite was MacSQL. But I'm looking forward to version 2 of MacSQL;
should be quite good.
--
+----------------------------------------------------------------------+
| Charlie Garrison [EMAIL PROTECTED] |
| Garrison Computer Services <http://www.garrison.com.au> |
| PO Box 141 |
| Windsor NSW 2756 Australia Ph: +61 2 4575-5247 |
+----------------------------------------------------------------------+
