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, September 30, 2021

How to rename a database to use lower case instead of upper case characters

›
At my customer's site, we have standardized the Oracle SIDs (System ID) to use lower case character. During an upgrade, the SID was ...
Tuesday, September 28, 2021

How to use opatch to check if Oracle Gateway for DRDA is installed

›
Log on to your oracle server, and type cd $ORACLE_HOME/OPatch ./opatch lsinventory -oh /full/path/to/oracle_home -details > /home/orac...
Wednesday, September 22, 2021

How to resolve ORA-48128 during export

›
Applicable to Oracle 19.3 and onwards. The following error may occur when you export data using Data Pump Parameter file: userid=sys...
Monday, September 20, 2021

PostgreSQL: how to use the to_date, to_char and cast conversion functions

›
Building on the example in my previous post , this is how you can use the to_date and to_char functions for predicates used against both t...

PostgreSQL: how to create a partitioned table using a conversion function

›
Consider the following table: CREATE TABLE myuser.mytable ( id integer NOT NULL, created_date timestamp without time zone NOT NUL...
1 comment:
Friday, September 17, 2021

How to solve error in pg_top stating "relation does not exist"

›
When you execute pg_top, you get to see the top database sessions in a way familiar to most people with experience from Unix environments....
Thursday, September 16, 2021

How to list the contents of a custom format PostgreSQL export file

›
List the content of a "custom format" export file created by pg_dump by specifying the -l flag : pg_restore /data1/exports/mu...
‹
›
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.