Oracle locates all queried data in the buffer of remote database and returns to you only those fields which you specified in 'SELECT' clause.
You may use COPY command to transfer data.