You could also export/import but it's kind of all or nothing, not 50%.

You could also spool the output to a flatfile, or a sql file and insert it to the database if you didn't want to use the dblink.