you can export the source, import into database.
create a tnsconection string from anywhere you want ( if the databases are of different versions, use the lower version of exp to export and same version of imp to import).
the process is done is steps ( accumilate them into a single script, depending on your OS).
1. exp the source table(s)
2. import into target ( you may need to truncate the target table before import. else add an option IGNORE=Y
to append the data)

----------------------------------------------------------------------

else
1. create a dblink in target to connect to the source.
2. truncate the target table in source.
3. insert into target_table ( select * from source_table@dblink)