Hi,
    There are two database A and B under one instance.
I want to insert some records of one table from database A to table of database B.

Whats the appropriate way?
Is there any direct way?

And if databases are under different instances then what will be the way?

Please reply ASAP

Thanks & Regards
Pawan

with federation and without federation....please provide solution for both.

no reply ??????

Pawan,

You can export the data from table A and import to the table B for both cases above.