Home » RDBMS Server » Server Administration » Dropping database link (19c)
Dropping database link [message #685884] Thu, 14 April 2022 08:08 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
Currentlly we use dblink to fetch data on UAT from Prod for reporting purpose.
We run those queries everyday on UAT.
The client is asking to drop all the dblinks.
What would be the best practice in this case to replicate data if there are no db links is available.

Thanks,
Vaun

[Updated on: Thu, 14 April 2022 08:10]

Report message to a moderator

Re: Dropping database link [message #685887 is a reply to message #685884] Thu, 14 April 2022 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

At first thought I see 3 "solutions":
  • Use export/import (data pump or old one)
  • Use SQL*Plus COPY command
  • Write a small program which connects to both db and reads the data in one and writes it in the other one

[Updated on: Thu, 14 April 2022 09:03]

Report message to a moderator

Re: Dropping database link [message #685889 is a reply to message #685884] Thu, 14 April 2022 10:41 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Another possibility: install an ORDS listener on the prod side, and use REST enabled SQL to extract the data with http calls?
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/21.2/aelig/rest-enabled-sql-service.html
Re: Dropping database link [message #685891 is a reply to message #685889] Fri, 15 April 2022 07:23 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Another possibility: Do not link PROD to any non PROD environment!
Re: Dropping database link [message #685892 is a reply to message #685889] Fri, 15 April 2022 08:37 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks.
Re: Dropping database link [message #685893 is a reply to message #685889] Fri, 15 April 2022 14:56 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi John,

Can we use REST utiity from Oraas to Oracle as well?

Thanks,
Varun
Previous Topic: Patch conflict
Next Topic: Unable to connect to pluggable database - Oracle Datase 12.2.0.1.0
Goto Forum:
  


Current Time: Thu Mar 28 18:47:47 CDT 2024