copying data from one computer to another, without export

I am working on a project where sometimes it would be handy to have the DB local (like when my IP connection goes out, or theirs does). I have installed Oracle 8 Personal and created all the tables. This helps quite a bit with compiling. Now I want to populate some of the tables with data. I have the free TOAD and that will create insert statements, but I thought that it would be easier, at least less steps, to do something like

insert into my_local_table values( select * from remote.schema.table );

My first try didn't succeed and I need to get back to work right now, but I thought that I would ask and see if I was at least on the right track.

Any example would be greatly appreciated. Received on Mon Aug 27 2001 - 09:34:38 CDT