Minimalistic Oracle

Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.

Wednesday, November 28, 2018

Changes in privilege "SELECT ANY DICTIONARY" in Oracle 12c

›
From version 12.1 and onwards, Oracle has introduced some changes to enhance security when granting the system privilege "SELECT ANY D...
Monday, November 19, 2018

How to use rman to create a backup-based clone on a remote server

›
It has been a while since I needed to use this technique, since we rely on storage snapshot clones these days. Sometimes though, a good old...
Wednesday, November 14, 2018

New parameter in dbms_redefinition.finish_redef_table in 12c

›
Oracle 12c adds a potentiall very useful feature to the dbms_redefinition package, in the procedure finish_redef_table: dml_lock_timeout ...
Monday, October 29, 2018

How do you configure an Oracle Golden Gate extract to run in Integrated Capture Mode?

›
There are different parameters valid for Golden Gate extracts, depending on which mode you choose (integrated mode or classical mode). * I...

Potential solution to Golden Gate error message "Parameter [INTEGRATEDPARAMS] is not valid for this configuration"

›
I was trying to set up an Integrated Capture in my Golden Gate environement, and kept getting the following error when starting my extract ...

How to lookup parameter definitions in Golden Gate 12.2

›
A potentially very useful feature when working with Golden Gate configurations is the ability to lookup parameter definition usage, with th...
Friday, October 26, 2018

How to avoid OGG-10470 during and "add trandata" operation

›
When configuring a table for an Oracle GoldenGate replication, you need to enable supplemental logging for the table. If you see the follo...
‹
›
Home
View web version

About Me

My photo
Name: Vegard Kåsa
My career as an Oracle DBA startet in 2001, when I acceptet a request to take on the responsibility as my current employer's DBA. From that point and onwards, managing Oracle databases has kept me busy and engaged. I enjoy my work, and particulary appreciate the constant learning and devlopment that comes with the job. From 2014, I am self-employed through my company Oric Consulting AS (Norway), and from 2024 Oric Consulting AB (Sweden) I currently live in Göteborg, Sweden, with my family.
View my complete profile
Powered by Blogger.