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 11, 2019

New security feature in Oracle 12.2: INACTIVE_ACCOUNT_TIME

›
A profile in Oracle 12.2 can now be configured with the setting INACTIVE_ACCOUNT_TIME, which specifies the maximum number of days an accou...
Wednesday, October 9, 2019

Oracle streams being terminated with Oracle 18c

›
As noted in the " Desupported features " section of the Oracle 18c documentation, Oracle Streams will be terminated in with the ...
Monday, September 16, 2019

How to work around ORA-03206 when running the RCU (Repository Creation Utility) used by ODI

›
During installation you may encounter the error ORA-03206: maximum file size of (13107200) blocks in AUTOEXTEND clause is out of range I...
Wednesday, September 4, 2019

How to create a proxy authenticated user in Oracle

›
Create a general user for authentication: CREATE USER APP_POOL IDENTIFIED BY app_pool_users123 DEFAULT TABLESPACE USERS TEMPORARY TABL...
Thursday, August 22, 2019

How to change location for the redo log files in physical standby database

›
Short background: After a cold restore of the database files from standbyserver1 to standbyserver2, the redo logfiles where incorrectly re...
Wednesday, August 21, 2019

How to create a compressed index using advanced index compression

›
Applicable for Oracle 12.1 and onwards. Basic syntax: CREATE INDEX MYIDX1 ON MYTABLE(COL1, COL2) COMPRESS ADVANCED LOW; The above st...
Tuesday, August 20, 2019

How to add a semicolon (or any other character) at the end of a line using vi

›
Open your text file in vi, and type :%s/$/;/g this will add a semicolon at the end of each line in your file.
‹
›
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.