My oracle database(11.2) and postgresql database(9.3.5)
My requirement is to extract the data from oracle database to postgresql database for that purpose i used oracle_fdw(foreign data wrapper concept).
I could extracted all the data of particular schema(oracle db).
I am able to extract the data of normal tables.but i am not able to access the meta tables like all_tab_columns
I created server and user and provided server details and user mapping details(sys privileges) while accessing time it's giving me error
ERROR: session for foreign table "all_tab_columns" cannot be authenticated SQL state: HV00N Detail: ORA-12571: TNS:packet writer failure