SQL*Plus COPY Command - Oracle Documentation

Usage To enable the copying of data between Oracle and non-Oracle databases, NUMBER columns are changed to DECIMAL columns in the destination table. Hence, if you are copying between Oracle databases, a NUMBER column with no precision will be ...

docs.oracle.com