116 questions
0
votes
0
answers
31
views
Different results when invoking function with raw sql and plsql [duplicate]
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 ...
0
votes
2
answers
190
views
ORA-22992: cannot use LOB locators selected from remote tables
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&...
- 3
0
votes
0
answers
71
views
PLS-00201: identifier 'DBMS_UTILITY.EXEC_DDL_STATEMENT@DB_LINK' must be declared
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(
'...
- 176
0
votes
1
answer
483
views
Database link without wallet
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 ...
- 45
0
votes
0
answers
50
views
PL/SQL: ORA-00904: "ArticleWarehouseCode": Invalid Identifier
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: ...
- 473
0
votes
2
answers
728
views
Retuning statement with dblink gives error
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 ...
- 199
0
votes
2
answers
264
views
MView from remote table over database link gets empty after recreation of table
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 ...
- 925
0
votes
1
answer
1k
views
Accessing table and column comments in Oracle for tables in SQL Server via databaselink
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 ...
1
vote
1
answer
183
views
Returning Multiple Values from Oracle Function over Database Link
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 ...
- 1,558
0
votes
1
answer
155
views
How to Import Google workspace data automatically to Big Query database?
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.
1
vote
4
answers
692
views
How To Prevent Database Links to Same Database in Oracle
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.
...
- 439
0
votes
1
answer
461
views
XA Datasource using Oracle DB links in Java EE Container managed transactions
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 ...
- 633
1
vote
0
answers
1k
views
How to proxy into another database user in Oracle database link, with kerberised authentication
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 ...
- 476
1
vote
1
answer
559
views
Using Oracle ON COMMIT option on materialized over database link
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 ...
- 535
0
votes
1
answer
149
views
Oracle Advanced Queues versus a Small Oracle Database Table
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 ...
- 535
1
vote
0
answers
1k
views
Oracle SQL - VIEW PUSHED PREDICATE not happening when using dblink
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&...
- 23
0
votes
0
answers
43
views
Problem with distributed query in procedure to populate data warehouse (Oracle)
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(
...
- 207
1
vote
0
answers
789
views
Link existing MS-Access database to SQL Server
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 ...
- 41
0
votes
1
answer
1k
views
Oracle to SQL Server ODBC link - Invalid identifier when using WHERE clause
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 ...
- 27
0
votes
1
answer
2k
views
Query and insert data into one db to another db
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. ...
- 161
0
votes
1
answer
181
views
Database Link vs. NFS
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?
0
votes
1
answer
490
views
why dosen't oracle database link show column with image type from sqlserver
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 ...
5
votes
1
answer
55k
views
ORA-03150: end-of-file on communication channel for database link
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 ...
- 313
0
votes
1
answer
282
views
how to insert sign/character (example: '²' or other language sign) from oracle database to postgreSQL
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 ...
0
votes
1
answer
2k
views
Oracle Database Link + Inner Join + To_Number Query
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. ...
- 557