How to do a large insert to a table

[hinermak]

COPY -
FROM <user>/<pwd>@SID -
TO <user>/<pwd>@SID -
INSERT <tbl_nm> -
(col1, col2, etc)
USING -
SELECT col1, col2, col3 -
FROM <Your table> -
WHERE <condition> ;

Be sure to use the "-" at the end of each line, will not work otherwise