Jeff (My Hero) is once again correct.

This is an SQL* command and can be used to insert data via a select statement, but I do not know is it will work in PL/SQL either.

I had to prepare a small doc on the SQL* COPY command for our developers since they can not use import/export to move their data. One of the major benefits with COPY is that you can set the commit level via ARRAYSIZE and COPYCOMMIT.

I'll E-mail you the doc if you like.

MH