Re: Database Link in local server

Hello,

Assuming I understood correctly maybe you can use global temporary tables in ADG to write data.

Regarding distributed queries I seen an useful video some time ago:

https://youtu.be/rDxYO6QQfsI

Thanks.

On Fri, Apr 30, 2021, 01:30 Cee Pee <carlospena999_at_gmail.com> wrote:

>
> We have a standby DB in a DR server open for read only. A user wants to be
> able to pull the data in the server in some schemas (call them schemaA,
> schemaB) and want to write data in other schemas (say schemaX, schemaY)
> after manipulation.
>
> Without replication ($$), one thought that comes to mind is having another
> DB, say workDB, in the same server which then can connect via a local DB
> link to the standby DB. I am assuming performance will not be bad because
> the data comes from the same server. Of course there will be additional
> resource usage, esp IO and CPU that need to be considered.
>
> One important thing that comes to my mind is the statistics. Is there a
> way to make the 'workDB' see the statistics in the remote database (the
> standbyDB) when the workDB queries come up with execution plans? This may
> sound silly, but you never know unless you ask.
>
> 19c, multi TB size warehouse.
>
> CP.
>

--
http://www.freelists.org/webpage/oracle-l