>How can I copy data from one table to another without using the copy to command?
>Thanks

Certainly, there are alot of other ways, e.g. you can SELECT ... INTO ARRAY/CURSOR and then INSERT/APPEND to another table.