(mdinh) I have encountered a very strange feature and wondering if anyone has experienced this.
Tag: Oracle
Error when starting #GoldenGate Extract against MS SQL Server
(Bobby Curtis) If you work with Oracle GoldenGate long enough, you will eventually have to setup against a Microsoft SQL Server. Being that GoldenGate is a heterogeneous application, this isn’t a problem; however there are small differences. One such difference is how the exact/replicat will connect
ORE video : Demo Code Part 2
(Brendan Tierney) The following is the second set of demo code from my video on using R in the Oracle Database. Check out the video before using the following code. The blog post for the video will be updated to contain links to all blog posts that have the various demo code.
Trace Files — 11 : Tracing the Optimization of an SQL Statement
(Hemant K Chitale) So far, the previous examples have been on tracing the Execution of SQL statements and/or the Execution Plan used.
How an Oracle error can send you the wrong way…
(Patch) At my current assignment I needed to create an update statement to copy data from one table to another. Quite a simple task, I would say, but an error or actually a constraint violation sent me the wrong way in finding my solution.
Automatic install of JDeveloper
(Martien van den Akker) A few weeks ago I wrote a little script to do a silent install of SOA/BPM QuickStart.
Oracle’s ANSI Join Syntax Can Result In Wrong Results
(David Fitzjarrell) Ever since Oracle provided their version of ANSI syntax it’s been improving with each release. Unfortunately some steps forward also take steps backwards.
Exporting solutions from #GoldenGate Studio
(Bobby Curtis) In doing some testing with Oracle GoldenGate Studio, I decided to create a test solution that can be moved from studio-to-studio. In order to move the test solution from studio-to-studio, it has to be exported first. This post will be about how to export a solution so it can be archiv
Peeking table block contents
(savvinov) Sometimes you want to know what’s inside a certain block. Of course, the most straightforward way to do it is by dumping block contents using ALTER SYSTEM DUMP DATAFILE contents and analyzing it.
Tuning ASM Rebalance Operation when using FLASH drives
(Natik Ameen) When disks are added to a diskgroup, the data on all the disks are spread out evenly. One of last steps in this process is to COMPACT the data and place it on the outer tracks of the disks.
