Search every field of every table for a particular value in oracle

In case you want to search a string or any other number in all tables inside a schema. Then there is a free tool available for it. I have tried many scripts and PL/SQL procedures to do this, but by far the best is the freeware tool DBSEARCH. It can be downloaded free from the … Continue reading Search every field of every table for a particular value in oracle

Block access to database oracle

This is a script to create a logon trigger for blocking third party tools like Toad, SQl Navigator etc from accesing a production database. The script is taken from: http://www.psoug.org/snippet/Block_TOAD_and_other_tools_516.htm and modified to include SQL Developer as well. Since these days it is the defacto tool to work on databases by developers. [sourcecode language="sql"] CREATE OR REPLACE … Continue reading Block access to database oracle

Schema Replication using Oracle Goldengate 11g (Installation & Configuration)

GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will be more closely coupled with Oracle products. Golden Gate is relatively simpler to use and monitor than Oracle streams. Below I will demonstrate how to configure ASYNC Schema Replication one side using Oracle GoldenGate 11g … Continue reading Schema Replication using Oracle Goldengate 11g (Installation & Configuration)