The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
80 views
+100

Multischema view for postgres , querying multiple databases

Im managing SaaS app where each customer has a separate database (Postgres 9.3) . I need to figure out the best way to aggregate and query this data ( READ-only ). I know postgres has problems with ...
0
votes
1answer
26 views

ORA-02049 and ORA-02063 Errors

Select For UPDATE NOWAIT is Performed on Table by 20 process in Parallel Below error is returned by the 4 failed processes out of 20 (16 Processes are Successful) SQL_UPDATE_ERROR- : SQL update ...
0
votes
0answers
9 views

Multischema view for postgres , querying multiple databases. [duplicate]

Im managing SaaS app where each customer has a separate database (Postgres 9.3) . I need to figure out the best way to aggregate and query this data ( READ-only ). I know postgres has problems with ...
2
votes
0answers
66 views

How to avoid hardcoding a database link name in a package body

I have a PL/SQL package that copies data from a remote DB2 database using a database link. To keep the package configuration-independent I wrapped the remote table in a view. But a single field in a ...
0
votes
2answers
166 views

Alternatives for Dblink in oracle?

we have an SSIS job that inserts data into a table in server A from data in table which is located in some other server B. For this,we are making use of dblinks to connect to other database . But, ...
0
votes
1answer
85 views

Setting up DBLink between two Sybase Databases

I am having dificulty finding anything on the net on this subject. I am tasked with creating a DBLink between two Sybase Databases. At the moment it's not yet clear if they will be on the same server ...
0
votes
2answers
976 views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ...
0
votes
1answer
121 views

PostgreSQL dblink password encrypted or not?

I have two PostgreSQL servers: server 1: 192.168.0.1 server 2: 192.168.0.2 I want to connect to the database on server 2 from server 1. I do it like this: SELECT ...
0
votes
0answers
109 views

ORA-08176 - is there any possible way to encapsulate lob direct load

ORA-08176 will be generated if a transaction encounters data changed by an operation that does not generate rollback data : create index, direct load or discrete transaction. If ...
0
votes
1answer
586 views

Problem using merge into a remote table over dblink

I'm attempting to perform a merge into a remote table, let's say on server A (over a dblink), using a local table on server B. Source and target databases are both on Oracle 10.2.0.3. We already have ...
1
vote
2answers
298 views

How to call Oracle's stored procedure from DB2 stored procedure?

I am new to writing stored procedures and wondering if it's possible to call a Oralce' stored procedure from DB2 stored procedure. I have a scenario where a trigger on a DB2 table will invoke a DB2 ...
5
votes
1answer
330 views

PostgreSQL: DBLink weird permission/connection error

The goal is to (1) create a connection, (2) return a view of another database, and (3) close the same connection all to be stored in a view (no stored procedure or embedded password). I came up with ...
1
vote
0answers
289 views

Calling a function in remote database inside a stored procedure

There are 2 Oracle databases with pseudo names Remote and Local. I have a function in Remote called FUS.F_Return_10 which simply returns 10 for testing purposes, where FUS is a schema name. In Local I ...
1
vote
3answers
246 views

Altering same table across multiple databases

I have multiple databases on the same instance and I am in the process of updating a table schema that must propagate across all the databases. I am not sure I know what the right procedure for this ...
1
vote
0answers
479 views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...