This is a short note just to say I’m happy to have my first GitHub project.A few months ago I wrote a blog post and a python script (on gist)
This is a short note just to say I’m happy to have my first GitHub project.A few months ago I wrote a blog post and a python script (on gist)
Apparently, quite a few people ran into this situation before, so I got a few correct answers (some on Twitter, some on LinkedIn, and some as comments to the original
I posted my first challenge almost 2 years ago and there was a lot of interest in it. Today I post another one. Many years ago I saw this strange
I had a talk with a customer/colleague that got me thinking about a strange case of multitenant configuration. The chat was about an environment with two data centers and data
Next month RMOUG (Rocky Mountain Oracle User Group) will have their annual Training Days conference in Denver. In the past, being in Israel, I wasn’t exposed to most of these
I’ve installed quite a few PSUs in my professional life, but this time, it was something else. I’m talking about a RAC environment with 2 nodes and a database containing
I did some testing with impdp for a client. They asked me to write a procedure to import a set of tables from a production environment to a testing database.
In the previous post I talked about the order of predicate execution based on the predicate position and inline view.As promised, in this post I’ll add statistics and see what
Resumable operations are operations that can be suspended instead of failing, allowing us to fix the problem and resume the operation. When importing data using impdp, if (for example) a
In my previous post, I wrote about the parsing operation and what happens first. In the footnote I said that the order doesn’t affect performance, the cost based optimizer doesn’t