Questions tagged [database-link]
The database-link tag has no usage guidance.
46
questions
0
votes
3
answers
653
views
How do you retrieve connect strings for Oracle database links if not in TNS
I am DBA for an Oracle 19C database which has a number of database links in it. Some of these links are local, to other instances within our firewall, and others are remote, linking to databases ...
- 37
0
votes
1
answer
1k
views
Create a database link as a user while current schema is different
I have the following situation in an Oracle database.
I am user Bob on a local database, LOCAL, and the current schema I am in is not the user's schema, but a different one, let's say Alice. What I ...
- 103
0
votes
0
answers
572
views
Oracle 19c Select Query with Database Link
How can I use the following query with database link:
set pages 999
col "Size MB" format 999,999,999
col "Objects" format 999,999,999
col OWNER for a25
select obj.owner "Owner&...
- 29
0
votes
1
answer
98
views
Connect two remote oracle databases as a schemas on each other
This Question is about Oracle Database.
I have two remote databases DB_1 and DB_2, and I have two schemas on each database:
Schema DB_1 and Schema DB_2 on database DB_1, and Schema DB_1 and Schema ...
0
votes
0
answers
89
views
MS SQL Server Enterprise 2016 is truncating the audited select statements, how do we fix it?
TL;DR;
I am getting SELECT as the audit output instead of the actual (suspected) query SELECT DISTINCT CONVERT(varchar, DecryptByPassphrase(getkey(N'key1'), FIELD1)) as DECRYPTED_FIELD1 FROM view1 ...
- 103
0
votes
1
answer
533
views
How to select from pdbs with a cdb user?
I have several store procedures, which analyze oracle logs using log miner. These procedures run on CDB user C##ADMIN which created for this manner.
Now I want to compare the logged values to the live ...
- 874
0
votes
1
answer
544
views
Creating a database link from Oracle Cloud server to remote access database
I work for a small company that currently use Apex to run reports on our accounts system. Oracle is installed on our local server and part of the data is gained via a database link to an access ...
- 3
1
vote
1
answer
652
views
Create a view with distributed Lobs
I have two Oracle 18c instances (instance 1 with schema DB1 and instance 2 with schema DB2) and I know that there ist a support for distributed lobs since 12.2. So i did the following:
CREATE TABLE ...
- 113
1
vote
1
answer
2k
views
How to create a DB Link to a Database which has failover in TNS
Could you please help me to understand how my DB LINK creation sql look like to a database (RAC env, Oracle 12c) which have fail over option in tns entry?
I read below post from Oracle-(not having ...
- 13
0
votes
2
answers
3k
views
Azure Database Link to another Azure database
How to query between two databases with the same server in SQL Database?
Currently we are aiming to link two azure databases that will update simultaneously.
Thanks!
- 29
3
votes
1
answer
3k
views
create one private database link for two users oracle
I am trying to create one private database link to be accessed by only two users but it gives me syntax error.
My code:
CREATE DATABASE LINK "mylink"
CONNECT TO USER1,USER2
IDENTIFIED BY ...
- 133
1
vote
1
answer
36
views
Dumping data from website's Database
I'm looking for ways to browse and dump the database of a particular content from the website. To be more specific i am collecting the database of the Skills designed for the device amazon alexa. Is ...
- 7
1
vote
0
answers
113
views
link multiple MS project to Access/Excel
sir
I have a large project tracking database used to track PMs, status, help needed, action items, reports etc. I keep the project schedule in a large MS-Project file. I've exhausted all efforts to ...
4
votes
1
answer
4k
views
Is there an equivalent to OPENROWSET in Oracle?
Is there an equivalent to OPENROWSET in Oracle?
From OPENROWSET (Transact-SQL):
This method is an alternative to accessing tables in a linked server and is a one-time, ad hoc method of connecting and ...
- 1,447
1
vote
0
answers
569
views
ORA-00604 (error occurred at recursive SQL level string) hides the real error
My multithreaded program inserts records into a table. ORA-00001 (unique constraint violated) should not be fatal.
But prod environment has a complex configuration with read-only schema and the table ...
- 282
1
vote
1
answer
2k
views
CREATE TABLE AS SELECT creates non-nullable columns
I am using the CREATE TABLE AS SELECT statement in Oracle 11g to get data from SQL Server 2012 via a database link.
Oracle creates all these tables with non-nullable columns and that causes me ...
- 303
1
vote
1
answer
7k
views
Import all database links using dbms_datapump
Source DB version: 11.2.0.3
Destination DB version: 12.1.0.2
I'm attempting to import all database links from one database to another using dbms_datapump. The code is running on the above ...
- 1,128
1
vote
2
answers
2k
views
Database link from Local Oracle 11g to Oracle Database Cloud Service 11g
We are using Oracle database from Oracle Database Cloud Service,
now we are not able to connect Cloud db from Local oracle db.
Somehow we created link using below commnd,
CREATE DATABASE LINK link_1 ...
- 211
3
votes
1
answer
2k
views
How to resolve foreign key references across different databases (iSeries and SQL Server)
I've got a system that has a DB2 iSeries database. We are rewriting a portion of the system and implementing it using SQL Server and Entity Framework.
Originally, I was lead to believe that there ...
- 131
1
vote
0
answers
281
views
Alter schema of Access 2013 database with linked table
I'm trying to change the schema of an Access 2013 table. I want to lengthen some of the text fields. When I change the schema and try to save I get dialog with Operation is not supported for this type ...
- 127
0
votes
2
answers
941
views
How to prevent users other than DBAs from creating database links
To begin, please keep in mind that I am a very green DBA. I have done prior research and have not really found anything too promising, or maybe it just seems that way because I am still struggling in ...
- 207
-1
votes
1
answer
100
views
Which one is best solution for future database structure?
I'm working on a big web application. so i need to create user_preference_table it has the marks for every users for each attributes. here attributes are games so in the user_preference_table i need ...
0
votes
2
answers
2k
views
Oracle: Inserting data using a database link
I am trying to use a SELECT query to populate a table in DB2 using a database link to DB1. I am using Oracle SQL Developer on a Windows 7 VM. I connect to DB2, and run the following query.
INSERT ...
- 103
1
vote
1
answer
11k
views
ORA-00933: SQL command not properly ended
I have created a database link to a remote database, MIGRERDOSSIER.US.ORACLE.COM, then I use it to insert records in a table in a local database. Here is the request I am trying to execute:
insert ...
- 629
3
votes
3
answers
3k
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 ...
- 139
0
votes
1
answer
107
views
Linking Two database to execute join query
I have a remote odbc connexion and an MySQL database in my localhost
i ask if there is a way to execute a join query ( linking the two database ) ?
thanks.
- 21
0
votes
1
answer
1k
views
When I convert the linked tables to local tables I got this error? [closed]
Referential integrity cannot be enforced between linked tables and local tables.
Enforcement of referential integrity will be dropped on all relationships between tables converted to local and tables ...
- 1
0
votes
1
answer
334
views
Oracle 11g accessing data in Oracle 7
I am working on a project that involves converting production data from an Oracle 7 DB to our system, which use Oracle 11g. In our other projects, we use DB link to access the other system DB, which ...
0
votes
1
answer
4k
views
Oracle - how to reference to a field%TYPE using database links?
I have this database which includes a couple of schemas. Say I need to access schemaONE from schemaTWO. To do this, I have created a database link named "DB_ONE_LINK".
I am able to access to ...
- 113
2
votes
1
answer
9k
views
Oracle Select Query Over Database Link Suddenly Hangs Endlessly
I have a query that's been in use for years and today it started hanging endlessly. I took the query apart and found the piece causing it to hang is a simple join on a primary key that should run like ...
- 215
0
votes
1
answer
5k
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 ...
- 180
3
votes
2
answers
15k
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 {....
andreybavt
2
votes
1
answer
2k
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?
- 340
1
vote
0
answers
232
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 ...
- 271
0
votes
1
answer
1k
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 ...
- 283
2
votes
1
answer
4k
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 ...
- 121
1
vote
0
answers
13k
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 ...
- 165
3
votes
1
answer
6k
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, ...
- 1,443
3
votes
1
answer
143
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 ...
- 31
0
votes
2
answers
6k
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 ...
- 169
4
votes
2
answers
5k
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 ...
- 143
37
votes
2
answers
326k
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 ...
- 1,053
2
votes
3
answers
4k
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 ...
- 380
6
votes
3
answers
13k
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 ...
- 297
11
votes
2
answers
17k
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 ...
- 1,874
3
votes
1
answer
2k
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.
- 23.8k