Dear Friends,

I have a small problem which I'm sure u people will be able to solve easily. My scenario is that I've 2 different databases, for example database1 & database2 on Oracle9i. Both databases contain the same no. of tables with the same type of structures. In short, both databases are identical. The only difference is that only database1 contains data.

Now, I've to develop a small application which will be automatically transferring selective records of database1 to database2.

Can anybody tell me with what oracle commands & methods the solution can be achieved??