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.

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...

How to add supplemental logging on a table

›
alter table scott.emp add supplemental log group gg_feed (feed_id) always; To reverse: alter table scott.emp drop supplemental log group ...
Thursday, October 18, 2018

What is the meaning of the "10G 11G 12C" value in DBA_USERS.PASSWORD_VERSIONS?

›
Since I wrote my post What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS? , Oracle 12c added yet another v...
5 comments:
Sunday, October 7, 2018

How to list all schemas and their sizes

›
If you want a list of schema sizes, join dba_segments with dba_users to limit the extract to users that are non-oracle maintained: set lin...
‹
›
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.