Tagged Questions
2
votes
1answer
61 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
1answer
98 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
136 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
931 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 ...
0
votes
2answers
969 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 ...
3
votes
1answer
242 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.
