Questions tagged [database-link]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
65 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&...
user avatar
0 votes
1 answer
36 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 ...
user avatar
1 vote
0 answers
57 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 ...
user avatar
0 votes
1 answer
78 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 ...
user avatar
  • 794
0 votes
1 answer
248 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 ...
user avatar
  • 3
1 vote
1 answer
298 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 ...
user avatar
  • 113
1 vote
1 answer
1k 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 ...
user avatar
0 votes
2 answers
1k 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!
user avatar
  • 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 ...
user avatar
  • 133
1 vote
1 answer
33 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 ...
user avatar
1 vote
0 answers
112 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 ...
user avatar
3 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 ...
user avatar
  • 1,375
1 vote
0 answers
553 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 ...
user avatar
  • 223
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 ...
user avatar
  • 211
1 vote
1 answer
6k 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 131
1 vote
0 answers
275 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 ...
user avatar
  • 127
0 votes
2 answers
806 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 ...
user avatar
  • 207
-1 votes
1 answer
99 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 601
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 ...
user avatar
  • 139
0 votes
1 answer
104 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.
user avatar
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 ...
user avatar
0 votes
1 answer
328 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 ...
user avatar
0 votes
0 answers
1k views

Datalink error when executing remote query

This afternoon i was working with an old datalink defined to transfer data from one database to other. It's the first time i've worked with this 'trick'. We use an specific user to work with the ...
user avatar
0 votes
1 answer
3k 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 ...
user avatar
  • 113
2 votes
1 answer
8k 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 ...
user avatar
  • 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 ...
user avatar
  • 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 {....
user avatar
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?
user avatar
  • 340
1 vote
0 answers
227 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 ...
user avatar
0 votes
1 answer
919 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 ...
user avatar
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 ...
user avatar
  • 121
1 vote
0 answers
12k 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 ...
user avatar
  • 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, ...
user avatar
  • 1,253
3 votes
1 answer
127 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 143
37 votes
2 answers
265k 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 ...
user avatar
  • 1,053
2 votes
3 answers
3k 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 ...
user avatar
  • 380
6 votes
3 answers
12k 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 ...
user avatar
11 votes
2 answers
16k 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 ...
user avatar
  • 1,834
3 votes
1 answer
1k 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.
user avatar
  • 23.5k