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, February 23, 2017

What is the INHERIT PRIVILEGES granted to PUBLIC in 12c?

›
I was checking which object privileges my user had made, and I found the following: select * from user_tab_privs_made; GRANTEE TA...
Wednesday, February 22, 2017

How to alter a subpartition template

›
Use the SET SUBPARTITION TEMPLATE clause, like this: ALTER TABLE SCOTT.MYTABLE SET SUBPARTITION TEMPLATE (SUBPARTITION SP_2014 VALUES (...

Insert As Select statements

›
The syntax for an Insert As Select Statement would be: INSERT INTO MY_INTERIM_TABLE (E_ID, ENAME,CREATED_DT, REVISION, FISCALYEAR, FPERIOD,...

How to create a range partitioned table

›
Using interval partitioning: A simple example of an Interval Range Partitioned table: CREATE TABLE DOCUMENTS ( DOCNAME VARCH...

How to speed up statistics gathering on a large table - inter object parallelism

›
When you use parallelism to analyze a specific object, Oracle refer to this as "Inter Object Parallelism". In short, the Degree O...

Oracle 12c feature: Online statistics gathering

›
Oracle 12c introduced the concept of "online statitistics gathering". The white paper "Best Practices for Gathering Optimiz...
Monday, February 20, 2017

How to solve ORA-14323: cannot add partition when DEFAULT partition exists

›
You have a partitioned table with an overflow partition, and you try to add another partition to it: ALTER TABLE RECEIVED_DOCUMENTS ADD PA...
‹
›
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.