On Fri, 2023-03-24 at 08:00 +0000, Inzamam Shafiq wrote: > Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we > have to > schedule jobs to insert data in actual schema from foreign tables, so some > delay might be there.
In addition to the commercial tools that Christophe mentioned, and which might be your best option, let me point out that ora_migrator (https://github.com/cybertec-postgresql/ora_migrator), which is open source and based on oracle_fdw, offers some degree of what you are looking for using a cursor-based soution. Certainly net refined and certainly not feasible in cases with high transactional workload, but perhaps it can be useful for you. Yours, Laurenz Albe
