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

TRY

---
insert into my_local_table select * from schema.table_at_remote_db;




moiznet2002_at_yahoo.com (M. Moiz) wrote in message news:<53b2483d.0108280921.4dab70f9_at_posting.google.com>...


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