The Log Buffer Edition once again is sparkling with some gems, hand-picked from Oracle, SQL Server and MySQL.
There are many ways to migrate a database from A server to B server like Datapump, RMAN,etc. Using the combination of datapump and GoldenGate to migrate your database on cross-platform will minimize your down-time to even three minutes. This method can be used for any size database from MB to TB level. Here is a…
Yes you can still disable triggers per-session in Oracle 126.96.36.199, but you have to have a GoldenGate license, set the
enable_goldengate_replication parameter, use a program name that starts with
replicat, and set your module to
The method of disabling triggers requires Oracle 188.8.131.52+ or 10.2.0.5+, plus execute permissions on sys.dbms_xstream_gg. Since it’s a call to an XStream package, it may also require a XStream license. So if I haven’t scared you away yet, here’s a quick testcase: