| Dropping database link [message #685884] |
Thu, 14 April 2022 08:08  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
