Table access

Hi all,
I am using Enterprisedb 8.2 Version
currently I am using 2 databases i.e
1.Testdb
2.Productiondb

My problem is how to access testdb table into productiondb.

Please help me.

Regards,
Kiran

Upgrade to 8.3R2 and use the Oracle style dblinks:

http://www.enterprisedb.com/docs/en/8.3/oracompat/EnterpriseDB_OraCompat_EN_8.3-49.htm

You'll need to be running Advanced Server 8.3R2 however. If you want to use postgres, use postgres dblinks:

http://www.postgresql.org/docs/current/static/dblink.html

--Scottie

Hi,
Thanks for your replay.
i am facing problem to create dblink .

my username is enterprisedb
password is edb

CREATE "PUBLIC". DATABASE LINK access
CONNECT TO enterprisedb IDENTIFIED BY 'edb'

i am using above syntax to create dblink it will display error.

Error message : syntax error at or near ""PUBLIC"" at Position: 9.

Please help me.

Sorry for the delay Kiran, I've been traveling a lot lately.

I think the problem you're having is the double quotes surrounding public and the '.' before the word database. I think the syntax you want is:

CREATE PUBLIC DATABASE LINK ....

Take a look at the docs:

http://www.enterprisedb.com/docs/en/8.3/oracompat/EnterpriseDB_OraCompat_EN_8.3-49.htm

Hi,

Thanks for your replay,

I got it,its working fine.

Regards,
Kiran