Skip to main content
116 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
31 views

Well I have 2 distinct Oracle 12c databases, lets name them db1 and db2 I have a link from db1 to db2 (DBL_DB2), also grants for execution of pkg2 which contains procedure 2, which we call proc2 (in ...
Ali Aasal's user avatar
  • 1
0 votes
0 answers
144 views

I am trying to insert data from a couple different tables in 2 different databases using database links. If I run the select query on it's own, it runs without error and returns the expected results. ...
CRayGo's user avatar
  • 21
0 votes
2 answers
206 views

I took the SQL down to the very very bare basics and it still fails on the Insert statement. ORA-22992: cannot use LOB locators selected from remote tables -- CREATED A TEMP TABLE DROP TABLE "ABC&...
B-Rent's user avatar
  • 3
0 votes
1 answer
600 views

I have 2 database links that have the same db link name, but different service name. As sys dba, I try to drop the one with the wrong TNS info, but I keep getting the "database link not found,&...
BFF's user avatar
  • 396
0 votes
0 answers
71 views

I am trying to run a DDL statement, from an Oracle database on a Postgres database, through the procedure DBMS_UTILITY.EXEC_DDL_STATEMENT like this: begin dbms_utility.exec_ddl_statement@DB_LINK( '...
Diogo dos Santos's user avatar
  • 176
0 votes
1 answer
305 views

There is a table called TableA and anther table called TableB both of them are in same sever i want to create a viwe called TEST in TableA which takes Username, ID columns to the view from suser table ...
Vinuka Osura's user avatar
  • 306
0 votes
1 answer
492 views

I am currently working on creating a database link to query data from an on-premises Oracle database. Although I have a working connection string, I don't have access to the server itself. When I ...
Jean Simas's user avatar
  • 45
0 votes
1 answer
100 views

We have problem when we want catch data from Oracle XE 21c over db link from database MySql 8.0.32, when we use where condition on select the results are waiting for a very long time. For example : ...
Dubravko Demser's user avatar
  • 1
0 votes
0 answers
51 views

I'm trying to insert data from DB Oracle (Sql Developer) to SQL Server through dblink oracle, but when I run the code, I get this error message: Report error - ORA-06550: riga 16, colonna 64: PL/SQL: ...
Scripta14's user avatar
  • 473
1 vote
1 answer
588 views

How to drop a table if it exist in oracle with dbLink?I am here trying to connect to remote database using DBLink in oracle.I am using oracle sql developer. DROP TABLE TableName@dbLinkName. This ...
coder11 b's user avatar
  • 199
0 votes
2 answers
730 views

I have created a table with generated identity column .script below CREATE TABLE "TABLESAMPLE" ( "DESCRIPTION" VARCHAR2(2 BYTE), "TID" NUMBER(5,0) GENERATED ALWAYS AS ...
coder11 b's user avatar
  • 199
3 votes
1 answer
194 views

I have a very slow query due to scanning through millions of records. The query searches for how many numbers are in a specific range. I have 2 tables: numbers_in_ranges and person table Create table ...
Mariana's user avatar
  • 379
0 votes
2 answers
264 views

DB-Server 1: CREATE TABLE foo (id NUMBER); INSERT INTO foo VALUES (1); COMMIT; DB-Server 2: CREATE DATABASE LINK foo_link... -- Points to Schema of DB-Server 1. CREATE MATERIALIZED VIEW mv_foo ...
Toru's user avatar
  • 925
0 votes
1 answer
1k views

I have an Oracle 18c database. From this DB I need to create a database link to a Progress/Openedge 11.7 database to retrieve some data. I am somewhat familiar with Heterogeneous Services which uses ...
Paul Stearns's user avatar
  • 916
0 votes
1 answer
1k views

I use an Oracle database, where I have a database-Link to a Microsoft SQL Server database. I need to access the comments for tables in the Microsoft SQL Server database from my Oracle database. Using ...
PercivalPersephi's user avatar
  • 1
0 votes
4 answers
1k views

I have two identical tables: original_table, destination table in two different Oracle database. -- Oracle 1 create table original_table ( my_id NUMBER(11) not null, my_fld CHAR(15), ) -- ...
JiboOne's user avatar
  • 1,558
1 vote
1 answer
192 views

I have two oracle databases: A and B. On database A, I have a function which returns user defined type: create or replace type my_type as object ( id number, f2 varchar2(4000), f3 ...
JiboOne's user avatar
  • 1,558
-1 votes
1 answer
642 views

i'm a beginner to Docker, hope everyone can help, much appreciated. I downloaded a docker image from my company repository and i managed to create a container in my local machine from the image, let's ...
akira's user avatar
  • 51
0 votes
1 answer
157 views

How to daily import Google workspace data automatically to Big Query database? I'm new to Big Query and i can do it manually but i want to automate this process. Thanks.
mohammed zaid's user avatar
  • 1
5 votes
1 answer
835 views

I am trying to fetch data from remote table. The data is expanded from seed set of data in local table using recursive CTE. The query is very slow (300 seed rows to 800 final rows takes 7 minutes). ...
Tomáš Záluský's user avatar
  • 12.3k
1 vote
4 answers
693 views

My Main objective is to write a PLSQL Procedure to create database links when host, port, service, username and password is given. There I need to block creation of database links to same database. ...
JEJC_JACALK's user avatar
  • 439
0 votes
1 answer
510 views

We have a Oracle 12.1 database where MAX_STRING_SIZE has been set to EXTENDED, enabling the use of VARCHAR2(32767) columns. We copy data via a materialized view and a database link to an Oracle 11.2 ...
wolφi's user avatar
  • 8,381
0 votes
1 answer
464 views

I have following environment: EAR application on WebSphere 9, container managed transactions using XA datasource for Oracle 19c database (let's name it database "A"). The problem is that ...
Nikola's user avatar
  • 633
0 votes
1 answer
2k views

How can I create a database link from Oracle on PL/SQL to SQL Server based on this picture: Example: the SQL Server installed in computer IP 190.168.0.1 and that computer user is MCHSQLSERVER password ...
Neng Vang's user avatar
  • 1
1 vote
0 answers
1k views

Background: 2 Database hosts(with users): DB1(UserA), DB2(UserA, UserB) A database link from DB1, UserA, created and works fine with the following SQL CREATE DATABASE LINK "DB_LINK" USING ...
Edison Lo's user avatar
  • 476
1 vote
1 answer
1k views

I have a Java code that connects to Database A. Database A has DB link to Database B. Both database are oracle. I make a JPA connection to Database A Then I run a query from joining a table from ...
Marco's user avatar
  • 97
1 vote
1 answer
565 views

I have a question. I have a table on database 1 called Distribution_id which will hold no more than 2000 records at a time, I have a materialized view called Mv_Distribution_id which is a copy ...
Shaun Kinnair's user avatar
  • 535
1 vote
1 answer
2k views

I'm trying to create a database link on one database, so I can view tables on another database. The password to the other database is Bl$nk-d8prd, it doesn't seem to like the "-" in the password Bl$...
Shaun Kinnair's user avatar
  • 535
0 votes
1 answer
154 views

I'm looking for a simple way to communicate between two databases, there currently exists a database link between both database. I want to process a job on database 1 for a batch of records (batch ...
Shaun Kinnair's user avatar
  • 535
0 votes
0 answers
971 views

So I'm trying to create a database link between oracle and postgresql in the same server, and when I try to do a select it shows me this error. I've been looking for some answers in different forums ...
Jolvary Jimenez Ortiz's user avatar
  • 1
1 vote
0 answers
1k views

I'm having performance issues executing the following query (Q1): select z_out.*, a_out.id from orders a_out, test z_out where a_out.id=z_out.id and a_out.created>trunc(sysdate) and rownum&...
zyky2000's user avatar
  • 23
0 votes
1 answer
348 views

I'm creating a function that accepts two parameters. And one of my parameter will serve as the database link for my statement. I've tried concatenating it. How will I be able to achieve this? It ...
user9531765's user avatar
  • 1
0 votes
0 answers
47 views

I have a problem with a procedure that I will use to populate a table in the data warehouse. I'll try to exemplify. I have three types defined as follows: create or replace type room_t as object( ...
Paolopast's user avatar
  • 207
2 votes
2 answers
2k views

I am new to Oracle world. I have recently created a Database Link in Oracle to fetch the data from SQL Server and I am able to fetch the data. SELECT * FROM emp@dblink The above query fetching all ...
SumanKumar's user avatar
  • 374
1 vote
0 answers
793 views

I have an external application that uses a MS Access database to store its data. I do not want to touch anything here, because the application works very good for me. I have now created a own ...
Aposchi8's user avatar
  • 41
0 votes
1 answer
3k views

I have three Oracle databases connections (XE, XE_HR and XE_SBD_HR). I've tried to create private database link with fixed user that connects as HR using HR password with below query on XE_SBD_HR: ...
smiarooo's user avatar
  • 3
0 votes
1 answer
1k views

I need to query data from SQL Server in Oracle using an ODBC database link. I have created the necessary configuration in Oracle to allow me to access the SQL Server database and query the data. When ...
der_roedie's user avatar
  • 27
0 votes
2 answers
6k views

I tried each of the following - none worked: [oracle@localhost]$ sqlplus system/oracle@SID_NAME [oracle@localhost]$ sqlplus system/oracle@localhost:1521/SID_NAME [oracle@localhost]$ sqlplus system/...
Kapil Vyas's user avatar
  • 667
0 votes
1 answer
2k views

I need to query data from one oracle database table and insert into another table in a different database, In the sense assume there are two databases called A and B. A has a_table and B has b_table. ...
Ishara Kularatna's user avatar
  • 161
-2 votes
1 answer
714 views

How to create database link between three instances? For eg i have database named orcl,orcl1,orcl2 how to link them? Thanks
user avatar
0 votes
1 answer
187 views

What would be faster to migrate data from an old Oracle DB server to a new server, using a database link, or create a shared directory via NFS between old and new server to move data?
Fuad Nour Eddin Damra's user avatar
  • 3
-2 votes
1 answer
70 views

I have a USER1 in DATABASE1 and USER2 and USER3 in DATABASE2. I am given the credentials of USER2 from which i can select only few tables on USER3. Now the requirement is, i have to create a ...
Sunil Kumar's user avatar
  • 17
0 votes
1 answer
499 views

we have 2 server : 1-sqlserver 2012 on windows 2012 2-oracle 11g on linux we want to show information from table1 in sql server on oracle database and created database link between them when i ...
Morteza Zahedi's user avatar
  • 3
1 vote
1 answer
807 views

I have several Oracle databases where my in-house applications are running. Those applications use both dba_jobs and dba_scheduler_jobs. I want to write monitoring function: check_my_jobs which will ...
JiboOne's user avatar
  • 1,558
5 votes
1 answer
55k views

In an Oracle database there's a big PL/SQL procedure being executed periodically that copies data from one DB to another one through a database link and it is failing after some hours with the ...
detoro84's user avatar
  • 313
1 vote
1 answer
7k views

I need to convert a database link that I have in Oracle from a normal public database link to a public shared database link. I ran the following as my user with DBA privileges to make the link shared:...
Andrew Mairose's user avatar
  • 11.1k
0 votes
1 answer
282 views

I am trying to insert data from Oracle Database to PostgreSQL. In Oracle Database, It was success with standard statement: insert into "schema"."table"@dblink values (2, 'test'); But when I added ...
kuroshaker's user avatar
  • 1
2 votes
0 answers
41 views

I am new in oracle (about 6 month ), I manage 2 Database, let say DB_A and DB_B, both is Oracle database, DB_A have Public database link to DB_B, this dbLink is used in package function to get data ...
amincahcepu's user avatar
  • 43
0 votes
1 answer
2k views

DatabaseA - TableA - FieldA VARCHAR2 DatabaseB - TableB - FieldB NUMBER [dblink created] SELECT * FROM TableB@dblink b INNER JOIN TableA a ON b.FieldB = a.FieldA There are 2 complications. 1. ...
wervdon's user avatar
  • 557
0 votes
1 answer
664 views

I have a database link to a MS Access database in an Oracle database using Oracle's Heterogeneous Services. Some of the Access table column names are longer than the Oracle allowed 30 characters. As ...
steve4321's user avatar
  • 33

1
2 3