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 succed 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.