Stack Overflow
Stack Overflow

Questions tagged [database-link]

108 questions
0
votes
2 answers

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 IDENTITY MINVALUE 1 MAXVALUE 99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER …
coder11 b
  • 99
  • 5
0
votes
2 answers

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 REFRESH FORCE AS SELECT * FROM…
Toru
  • 905
  • 1
  • 9
  • 28
0
votes
1 answer

Can I create a database link from Oracle 18c to a JDBC data source with just the proper JAR file?

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 ODBC drivers to connect to other data sources. But…
Paul Stearns
  • 856
  • 9
  • 30
0
votes
1 answer

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 the script below I get the values for owner,…
PercivalPersephi
  • 1
0
votes
3 answers

ORA-01406 when copying data from one Oracle database to another with different Unicode

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), ) -- Oracle 2 create table destination_table ( my_id …
JiboOne
  • 1,438
  • 4
  • 22
  • 55
0
votes
1 answer

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.
mohammed zaid
  • 3
  • 3
0
votes
1 answer

Oracle: Cannot copy data from a max_string_size=extended to a max_string_size=standard database

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 database. Everything runs smootly for three years,…
wolφi
  • 8,091
  • 2
  • 35
  • 64
0
votes
1 answer

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 datasource (in some transactions), i.e. database "A" is…
Nikola
  • 554
  • 1
  • 4
  • 20
0
votes
1 answer

Create Oracle database link to SQL Server

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 is 12345678 and the server name of SQL Server is…
Neng Vang
  • 1
  • 2
0
votes
1 answer

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 Distribution_id table on database 2. I want to do a…
Shaun Kinnair
  • 495
  • 2
  • 10
  • 27
0
votes
1 answer

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 code for each batch of records), once the process…
Shaun Kinnair
  • 495
  • 2
  • 10
  • 27
0
votes
0 answers

ORA-28545 NET8 ERROR Database link oracle to postgresql

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 but my low knowledge about it doesn't let me…
Jolvary Jimenez Ortiz
  • 1
  • 1
0
votes
1 answer

DB Links as Parameters in a Function

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 shows this error ORA-00923: FROM keyword not found…
user9531765
  • 1
  • 1
0
votes
0 answers

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( ID INTEGER, n_seats INTEGER, cinema ref…
Paolopast
  • 197
  • 1
  • 11
0
votes
1 answer

Cannot connect with database link in Oracle

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: CREATE DATABASE LINK DATABASE_LINK_1 CONNECT TO HR…
smiarooo
  • 3
  • 2
1 2 3 4
5
6 7 8