On Tuesday 07 October 2003 07:29, Deepa K wrote: > Hi All, > Is it possible to insert n rows with 1 or 2 invalid rows > using copy command. I used it, it rollbacks everything even if 1 row > gets an error. Is their any other way to do it.
You need to remove the bad rows. This is IMHO a "Good Thing" (TM) although it can be irritating. You should get a line number to indicate where the problem rows are. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
