EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Db link  XML

Forum Index » Standard Server
Author Message
[Post New]4 Mar 2010 22:56:54
    Subject: Db link
[Up]
kiran_kumar_2

Member

Joined: 3 Mar 2010 09:47:03
Messages: 16
Offline
Hi,

How to create db link in enterprisedb8.2.
is there any change in configuration files ?






[Post New]5 Mar 2010 01:42:42
    Subject: Re:Db link
[Up]
dharmendra_goyal

Member

Joined: 26 Feb 2010 01:15:05
Messages: 41
Offline
Hi,

You can not create database link in enterprisedb8.2.

You need to upgrade your version. They are supported 8.3 onwards.

Dharmendra Goyal
www.enterprisedb.com
[Post New]5 Mar 2010 23:11:50
    Subject: Re:Db link
[Up]
kiran_kumar_2

Member

Joined: 3 Mar 2010 09:47:03
Messages: 16
Offline
Hi,
Thanks for your replay.
Now i am creating dblink in enterprisedb8.3 version.
db link is created successfully.
but i will try to access another database table using dblink it will display error.

Error Message : unable to load OCI library: The specified module could not be found.
at at Hint: Either the ORACLE_HOME environment variable or oracle_home setting must be defined at the time you start the server.

how to set ORACLE_HOME environment variable ?






[Post New]8 Mar 2010 01:47:55
    Subject: Re:Db link
[Up]
dharmendra_goyal

Member

Joined: 26 Feb 2010 01:15:05
Messages: 41
Offline
On unix based os you can set it by executing command: export ORACLE_HOME='path of your oracle server'

In windows set it in environment variables.
[Post New]8 Mar 2010 21:04:26
    Subject: Re:Db link
[Up]
scottiebo

Senior member
[Avatar]

Joined: 23 Oct 2005 21:05:02
Messages: 197
Offline
You would set this in the 'postgresql.conf' file of your Advanced Server instance. The configuration entry doesn't exist in the default file, just simply edit the file and add:



anywhere within the file.
--Scottie
 
Forum Index » Standard Server
Go to:   
Powered by JForum 2.1.8 © JForum Team