Transfering data from one database table to another database table

[sudheer_nm]

Hi

My requirement is to transfer data from one table to another table of different database. So I think sql copy command only for copying tables between databases and this won't help.

Can I use like 'Insert into T2 as select * from T1 where '
where T1 is a db_link name for the second database and T1 is a table in the first database