You could use the COPY command in SQLPlus (look in the SQLPlus docs). It doesn't require dblinks or export/import. It allows you to copy any recordset you can think of defining in the SELECT statement clause.