View instead of synonym

Originally Posted by
balajiyes
....
FROM (
SELECT /*+ DRIVING_SITE (T) NO_MERGE FULL(t) FULL(ct) */
....
FROM
tap --remote_table accessed by dblink -> synonym remote database
, calendar_time ct -- table local database/schema
WHERE t.source_system_id = '016'
....
After you check what Pablo recommends and you still have an issue, change the "tap" from synonym to a view:
Code:
CREATE OR REPLACE VIEW tap
AS
SELECT *
FROM remote_table@dblink;
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb