Re: Database Link in local server

Hi Cee,

I'm not sure what do you mean by "see statistics". If you mean can CBO on your "workDB" get required statistics from active standby through a dblink, then - yes, of course. No difference if that's active standby or not.

Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner Oracle ACE Associate
http://orasql.org

On Fri, Apr 30, 2021, 05:16 Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> No can do. You can do that with Golden Gate or logical standby DB, but
> not active DG.
>
> On 4/29/21 6:30 PM, Cee Pee 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.
> >
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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