Database Links Oracle Full pushdown

vinaykp · Senior Member Joined: 15 Jul 2010 Posts: 31

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