471,354 Members | 2,104 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

COPY COMMAND

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.

TIA

--
regards,
Deepa K.

Nov 12 '05 #1
1 1690
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Sarah | last post: by
2 posts views Thread by Steve Franks | last post: by
4 posts views Thread by Jon Asher | last post: by
reply views Thread by Robert Fitzpatrick | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.