Top "Dblink" questions

An object or module that enables access to a remote database.

How to use dblink_connect and dblink_connect_u

I have two databases in Postgres and want to access the data from one database to other database tables. I …

Read More
sql database postgresql postgresql-9.2 dblink
Using Partition on oracle table from a DB link

I am working on Oracle 9i my question is: can I use a partition over a table through a dblink …

Read More
oracle partitioning oracle9i dblink
Synonym or view over dblink

We are writing some interfacing routines in PL/SQL to transfer data between several oracle database by using another oracle …

Read More
oracle view synonym dblink
Copying metadata over a database link in Oracle 10g

Thanks in advance for your help experts. I want to be able to copy over database objects from database A …

Read More
oracle metadata dblink
ORA-01031: insufficient privileges when inserting via dblink

This works: (connect to some_db) INSERT INTO some_schema.some_table(id) VALUES (some_schema.some_table.nextval); THis …

Read More
oracle oracle10g privileges dblink ora-01031