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@xxxxxxxxx
office 949-754-1203 mobile 425-802-9603
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Mladen Gogala
Sent: Monday, December 16, 2019 3:46 PM
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
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&data=02%7C01%7Cclay.jackson%40quest.com%7Cc0d83417925743fc336b08d78282444b%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637121368307070100&sdata=9GJ7mQeJpn1nCuF3jAKdOgvIIK%2B5kVx1384MDx93LBY%3D&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&data=02%7C01%7Cclay.jackson%40quest.com%7Cc0d83417925743fc336b08d78282444b%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637121368307070100&sdata=JV4rLhF5v032oBsPwCA%2FhZ5qr7rPCaM%2BF0l5H9A8f0Q%3D&reserved=0
��i��0���zX���+��n��{�+i�^