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.

Tuesday, December 10, 2019

What is the Asynchronous Global Index Maintenance introduced in Oracle 12.1?

›
Asynchronous Global Index Maintenance, also called Deferred Global Index Maintenance, means that Oracle will maintain global indexes during...
Tuesday, December 3, 2019

How an incorrect password file format can stop the redo apply process (MRP0) on standby database

›
Error in dgmgrl shows: DGMGRL> show configuration; Configuration - DGConfig1 Protection Mode: MaxPerformance Members: proddb01...
Wednesday, November 27, 2019

How to move a datafile online in Oracle 12.1

›
Starting with Oracle 12.1, you can move datafiles online . Generate move-script: select 'alter database move datafile ''...
Tuesday, November 26, 2019

How to execute a *.sql file using psql in a PostgreSQL database

›
There are two ways: 1. Already connected to the correct database: postgres=# \connect proddb01 You are now connected to database ...

How to list the databases in a PostgreSQL instance

›
Connect to the default database: psql List your databases: select oid as database_id, datname as database_name, datallowco...
Thursday, November 14, 2019

How to move XML LOB segments in a partitioned table to a new tablespace

›
The examples used in this article is based on Oracle 18c. When moving a partition with XMLTYPE columns to a new tablespace, the LOB obje...
Tuesday, November 12, 2019

How to convert a non-partitioned table into a partitioned table in Oracle version 12.2 and onwards

›
With Oracle 12.2 and higher versions, it is really simple to convert a non-partitioned table to a partitioned table: you can now use the ...
‹
›
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.