set copycommit 999
set arraysize 999

COPY FROM USER/***@ABC TO USER/***@XYZ -
INSERT/REPLACE/APPEND Table_xyz -
USING SELECT * FROM Table_abc

This is basic syntax, look docs for specifics on restricts, parameters , error messages.