Hi, Dblink_Ora_* functions are useful for getting oracle connection into PostgresPlus Advanced Server. i.e, we can retrive oracle data from postgresplus. Please find the steps how to proceed. Step 1 ====== For doing dblink_ora* setup, we need a OCI(Oralce Client Interface which is nothing but libpq in Postgresql)file. If you have oracle 11*, then no need to download this file from any where. if not, we need to donwload this file from oracle site. Filename Required is : "libclntsh.so" in Linux "OCI.DLL" in Windows In Oracle 11g, you will get this directly from $ORACLE_HOME/lib. In this example, we have created a symlink for this from "/lib64" to "$ORCLE_HOME/lib". ln -s /home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so /lib64/libclntsh.so Step 2 ====== [root@localhost PGBAR]# chmod -R 766 /home/oracle/ Because, we are accessing this "libclntsh.so" as a enterprisedb user. Hence, we have given ...