Oracle - SQL - Table - Copy table from foreign host to here

COPY FROM USER@tnsname CREATE tablename USING SELECT * FROM tablename;