Strange developer ideas
Date: Mon, 16 Dec 2019 18:46:13 -0500
Message-ID: <47ac0ae9-f41b-df6b-b9b9-75166c55e258_at_gmail.com>
i've got a request from a developer to use logical standby as a DW database. The idea is that "DELETE" and "TRUNCATE" commands on the primary shouldn't be propagated to the standby. I told her that such thing can only be done by using the Force, not the normal Oracle tools. I sent this as an argument:
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:22699268606133
Now, the PM in charge of the project on which the aforementioned programmer is working sent me nastygram, accusing me of stalling and obstructing their project and colluding with Russians. I dared suggesting purchasing the Golden Gate license, which is completely capable of performing the required operation, but it wasn't interpreted as a helpful suggestion.
Just to cover all my angles, is anything like that possible with the logical standby? Has anyone managed to do anything like that? I have always considered standby a copy of the primary. Calling all Force users on this group, especially the ones dabbling in the Dark Side.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 17 2019 - 00:46:13 CET