oracle11g - How to access meta tables of oracle database from postgresql database -
my oracle database(11.2) , postgresql database(9.3.5)
my requirement extract info oracle database postgresql database purpose used oracle_fdw(foreign info wrapper concept).
i extracted info of particular schema(oracle db).
i able extract info of normal tables.but not able access meta tables all_tab_columns
i created server , user , provided server details , user mapping details(sys privileges) while accessing time it's giving me error
error: session foreign table "all_tab_columns" cannot authenticated sql state: hv00n detail: ora-12571: tns:packet author failure
postgresql oracle11g postgresql-9.3
No comments:
Post a Comment