Hi all here is the situation we are facing.
- We have a vendor software that using oracle
- We want to build some customised reports which will require the data on that database (lets call it vendor db) and some other data on our corp database (lets call it corp db, its also a oracle, both are 12cR1)
- Vendor don't agree us to add schemas to vendor db, so we cannot merge them to signal instances with 2 schemas
I can think up 2 options on my situation:
- 1. Add db link to corp db->vandor db, so that we can do our query in vorp db to access both data (big performance down grade ?)
- 2. create a real time sync copy of vandor schemas in corp db, do the query in corp db without db link
PS, I'm new to oracle so some terms I'm using like db sync, instances, schemas may not very accurate.
thx