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.

Thursday, February 27, 2020

How to install and configure a simple replication using Golden Gate 19.1 Classic Architecture

›
In this article I will show the steps to set up a very simple schema replication using the latest Oracle Golden Gate software, which is 19...
Tuesday, February 25, 2020

How to debug an ssh connection

›
ssh -X -v myserver.mydomain.com You can also use -vv and -vvv for more detailed debug information.
Thursday, February 20, 2020

What does the SELECT ... FOR UPDATE statement do?

›
From the documentation : The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock or update the rows until ...
Monday, February 17, 2020

How to export and import a schema in PostgreSQL

›
Schema exports and imports There are many ways to export a schema using pg_dump: Export the schema scott from db01, data only, no me...
Friday, February 14, 2020

How to list schemas in a PostgreSQL database

›
Use the "\dn" or "\dn+" for more details. They will list the schemas in the database you are connected to. When you ...
1 comment:
Thursday, February 13, 2020

How to list PostgreSQL database sizes

›
Use the psql shortcut \l+ , like this postgres=# \l+ gld List of databases ...
Tuesday, February 4, 2020

How to change configuration for your audit trail

›
This post is applicable from Oracle version 11.2 until present (Oracle 19 as per writing). Check the current settings: SELECT * FROM DB...
‹
›
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.