B SQL*Plus COPY Command - Oracle Documentation

Otherwise, COPY drops the existing table and replaces it with a table containing the copied data. destination_table ... Note that the tables are located in two different databases.

docs.oracle.com