I just have the idea like below. Please let me know if this is feasible.
insert into et_hn_nomns
select * from et_hn_nomns
I want to insert into a table in one database by selecting from a table in another database.
Can this be accomplished by any way, with out using DBLink.