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, July 31, 2020

How to connect to and start a specific database using dgmgrl

›
The data guard broker allows you to connect to any of the participating members of the configuration: oracle@myserver:[hdal]# dgmgrl / as s...
Wednesday, July 29, 2020

How to rebuild an index partition

›
To limit a rebuild to a specific index partition only, use the following syntax: ALTER INDEX SH.SALES_IDX4 REBUILD PARTITION SYS_P51490 ...

How to list index partitions and their sizes

›
To list index partitions for index SALES_IDX1: SELECT IDXPART.INDEX_OWNER, IDXPART.INDEX_NAME, IDXPART.PARTITION_NAME, IDXPART.TABLESPACE...
Tuesday, July 21, 2020

How to fix RMAN-04006 when cloning from active database

›
Background: During an attempt to clone database using active duplication, I received an error when testing my connectivity to the target...
Tuesday, July 14, 2020

Identity columns in Oracle 12c

›
The identity column introduced in Oracle 12c can be used in the different manners, according to your needs. Here are some basic examples: ...
Friday, June 19, 2020

How to run RMAN with debug information

›
Tested with Oracle 12.2 For example, to trace a duplicate database session, I have put the following into a file called "run_duplica...
Wednesday, May 13, 2020

How to use the TIMESTAMP_TO_SCN function

›
select timestamp_to_scn(to_timestamp('2020-05-11 14:36:22', 'YYYY-MM-DD HH24:MI:SS')) "scn" from dual; s...
‹
›
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.