Hello,
I am trying to get full pushdown for a DF where data is moved from table a(Database 1) to table b (database 2)( 1 to 1 mapping). Since they are on 2 different databases and 2 different servers, created a DB link to achieve pushdown.
Even after adding db link to the datastore, optimized SQL still doesn’t do full pushdown.
Any one had this issue before.
ENVIRONMENT : Oracle11g
DS: 14.2.1.700
vinaykp (BOB member since 2010-07-15)