datapump with query
hello
sorry if this is not the correct Community.
We need to move (copy) data from one database to another.
We plan to use datapump with dblink
Our main problem now is that the data to be copied is made with a query that involves 2 tables:
select a.field1, a.field2, b.field1, b.field2
from a, b
where a.id = b.id
and a.fec > sysdate -1
We havent found and example where datapump query involves fields from more than one table
tks
sorry if this is not the correct Community.
We need to move (copy) data from one database to another.
We plan to use datapump with dblink
Our main problem now is that the data to be copied is made with a query that involves 2 tables:
select a.field1, a.field2, b.field1, b.field2
from a, b
where a.id = b.id
and a.fec > sysdate -1
We havent found and example where datapump query involves fields from more than one table
tks
0