Re: copying data from one computer to another, without export

Ya..man you are on the right track...

Do it like in your example but be careful of permission for the local user on the remote database.

Hope this does it...
Moiz.

ScottMattes_at_yahoo.com (Scott Mattes) wrote in message news:<760023b4.0108240738.31a53fc6_at_posting.google.com>...
> 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.
Received on Tue Aug 28 2001 - 19:21:37 CEST