The database-link tag has no wiki summary.
0
votes
1answer
40 views
Oracle database link via ODBC to SQL Server does not recover automatically
I have a test environment with an Oracle 10XE database which is linked to an SQL-Server 2005 via an ODBC data source. For reference here I named the connection MSSQL_LINK. The production environment ...
3
votes
1answer
334 views
Oracle insert through dblink performance issue
I'm trying to do an insert as select to a table via dblink. The query looks like this:
Insert into MARS_SUPERVISORS_PUB@EDHPUB
select
{...}
from edhper a, edhper b
where ...
2
votes
1answer
73 views
Blocking incoming database links
Let's say there is an Oracle database A and another Oracle database B. Our database is A.
Is there a way to block database links from B to A?
0
votes
0answers
98 views
Materialized view for a yet-to-be-defined DBlink
In our product we have a main application with an oracle 11g DB and an optional module with another DB.
We want the two to communicate through a dblink and I was told to put some code for the ...
0
votes
1answer
124 views
How do I debug an ETL process that is unable to commit any records?
I used a DB link to connect to another DB and delete a couple of records. Later I ran an Informatica Workflow (ETL tool) to load data into that database using a DB connection that connects directly to ...
2
votes
1answer
157 views
Database Link from Oracle 10g on Windows over to MySQL database
Didn't see any answers on this subject so hoping for a miracle! :-)
I've got an Oracle 10g database running on Windows Server 2003 and I'd like to create a database link to an external MySQL database ...
1
vote
0answers
49 views
Combine Oracle locator instance with Oracle spatial instance with db link
we plan to have two oracle databases, one with oracle spatial installed, the other one just has the locator option.
Is it possible to create an oracle database link between the two databases in order ...
1
vote
0answers
1k views
Could Oracle ORA-08103 'object no longer exists' error be caused by size of undo_retention parameter?
Had a once-a-day long running data warehousing procedure that I had written that was failing about 50% of the time. Logs were showing ORA-08103 'object no longer exists'.
ORA-12012: error on auto ...
3
votes
1answer
478 views
How can I create a dblink from Postgresql 8.3 to SQL Server (2000 and 2008)?
I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008).
I want to setup two dblinks to the SQL Servers.
After googling, foruming, ...
3
votes
1answer
60 views
linking databases for reporting
I am attempting to design a simple reporting feature for some financial market data.
I have a few sets of data, and I am trying to figure out what will be the best way to organize the tables, in ...
0
votes
2answers
1k views
Oracle database link to MySQL database on RedHat Linux
I have an Oracle 11g database on a RedHat server and also have MySQL database on another RedHat server. I want to create a link to the MySQL server from the Oracle which allows me to execute queries ...
2
votes
2answers
1k views
Does Oracle cache queries when using a database link
Some vendor told us that we should not use database link between our database and theirs as the queries executed over a database link would not be cached, nor optimized.
I can't find any information ...
5
votes
2answers
8k views
Oracle: Quick way to list all database links
The title says it all, is there a way to quickly list all the current database links in oracle?
Something along the same lines as this, which lists the current user's tables:
select * from ...
2
votes
2answers
377 views
Determine last usage date of a linked server
We have a tonne of linked servers on our database server that we would like to clean up.
Is it possible to determine the last date a linked server was used? e.g. the last time a query was performed ...
3
votes
1answer
1k views
Error Querying MySQL server linked to SQL Server 2008
I've created a linked server in MS SQL Server 2008 to a remote MySQL server. When I try to query any tables, I get an error:
.tablename. contains no columns that can be selected or the current user ...
8
votes
1answer
3k views
How to connect to another db using stored procedures?
I need to get some data from an external db and make some calculations with it in another db, is it possible to connect to an external db from a stored procedure? Thanks guys.
PS.
Im using Oracle ...
3
votes
1answer
252 views
Is there a way to allow a proxy connection to use passed authentication in a public database link?
I think the answer to this is no, but I could be wrong. If nothing else it might be nice for others to be aware of this limitation of proxy connections.
