RE: Strange developer ideas

From: Clay Jackson (cjackson) <"Clay>
Date: Mon, 16 Dec 2019 23:57:53 +0000
Message-ID: <MWHPR19MB0141CC590385D5E7E402557B9B510_at_MWHPR19MB0141.namprd19.prod.outlook.com>


Ha! Sounds like some responses I've gotten to the same type of question. Of course, I suggest SharePlex, not GoldenGate 😊, but the result is usually the same. Something about horses and water comes to mind...

To answer the question, AFAIK, you and the folks that run Ask Tom are correct - can't be done. And I was surprised at the "mild" Ask Tom answer.

Clay Jackson
Database Solutions Sales Engineer
clay.jackson_at_quest.com
office  949-754-1203  mobile 425-802-9603

-----Original Message-----

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: Monday, December 16, 2019 3:46 PM To: oracle-l <oracle-l_at_freelists.org> Subject: Strange developer ideas

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.

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://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fasktom.oracle.com%2Fpls%2Fapex%2Ff%3Fp%3D100%3A11%3A0%3A%3A%3A%3AP11_QUESTION_ID%3A22699268606133&amp;data=02%7C01%7Cclay.jackson%40quest.com%7Cc0d83417925743fc336b08d78282444b%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637121368307070100&amp;sdata=9GJ7mQeJpn1nCuF3jAKdOgvIIK%2B5kVx1384MDx93LBY%3D&amp;reserved=0

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

--

https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&amp;data=02%7C01%7Cclay.jackson%40quest.com%7Cc0d83417925743fc336b08d78282444b%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637121368307070100&amp;sdata=JV4rLhF5v032oBsPwCA%2FhZ5qr7rPCaM%2BF0l5H9A8f0Q%3D&amp;reserved=0

i0zX+n{+i^ Received on Tue Dec 17 2019 - 00:57:53 CET

Original text of this message