I need to copy data from one table to another. the two tables have almost the same structure, but are in different databases. i tried wenn i try this, i get error cross database … not implemented Answer This is a really straightforward task. Just use dblink for this purpose: If you need to fetch data from external database on