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.

Friday, October 30, 2015

Syntax for setting hidden parameter in Oracle

›

Syntax example: alter system set "_system_trig_enabled"=TRUE scope=both;

Syntax for setting the default undo tablespace for the instance

›

ALTER SYSTEM SET undo_tablespace='APPS_UNDOTS1' SCOPE=BOTH;

Thursday, October 29, 2015

How to check your Operating System's code page for a particular character

›

I have been involved in several migration projects where we had to deal with Western European characters, which have invalid representation ...

Wednesday, October 28, 2015

How to work around ORA-29275: partial multibyte character when using chr function

›

If you need to check what is actually stored in a database table, meaning the internal representation, you can use the DUMP function. It w...

Monday, October 5, 2015

Is it possible to change the character set of the database by recreating the control file?

›

Question: Is it possible to change the character set of the database by recreating the controlfil? Answer: No, this is not supported. Doc...

How to pause an Oracle database

›

Sometimes it is useful to pause a database, and let it finish the running jobs at a later time. Particularly in environments with shared re...

Tuesday, September 8, 2015

How to recursively zip a folder and its subfolders

›

Use the -r flag to indicate recursive zipping: zip -r myfile.zip myfolder

‹

›

Home

View web version

About Me

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