RE: Strange developer ideas

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

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
office  949-754-1203  mobile 425-802-9603

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

From: <> On Behalf Of Mladen Gogala Sent: Monday, December 16, 2019 3:46 PM To: oracle-l <> 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:;;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


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

Original text of this message