from database to another database data load

does anyone tell me how to load data from one oracle database to another oracle database.

assuming:
database A is the source
database B is the destination

database B fields to be populated are C,D,E database A fileds to be loaded to database A are F,G,H

these fields have same data types

can i use this?

insert into table B(C,D,E)
values(select F,G,H from A);

i tried it, but it is not working. Is there a better way?

help! I'm a novice oracle programmer...

please email me..

thank you,
Glenn
glendc_at_sprint.ca Received on Sat Oct 18 1997 - 00:00:00 CDT