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.

Tuesday, December 27, 2016

How to analyze a specific partition only using dbms_stats

›
To analyze only specific partitions, including subpartitions, use the dbms_stats.gather_table_stats while specifying the directives PART_NA...
Wednesday, December 21, 2016

How to create a partitioned table using a subpartition template

›
Using templates for your subpartitions is a handy shortcut to avoid specifying attributes for every subpartition in the table. Oracle call...

How to remove the APEX option from the database

›
cd $ORACLE_HOME/apex sqlplus / as sysdba @apxremov.sql drop public synonym htmldb_system; drop PACKAGE HTMLDB_SYSTEM; If you have older A...
Tuesday, December 20, 2016

Will interrupting a "split partition"-command cause any harm to your database?

›
Will interrupting a "alter table split partition"-command cause any harm to your database? No, it will not. It is safe to kill t...
Sunday, December 18, 2016

How to create a common and a local user in a 12c multitenant database

›
In a multitenant container database, there are two types of users: * Common users, who are known in both the root containers and in all th...

How to display the current container in an Oracle multitenant database

›
You can display the current container your session is currently connected to using three different methods. First, connect to either the ...
3 comments:
Friday, December 16, 2016

How to change passwords for eBS schemas in an Oracle database

›
In an Oracle database supporting eBS, there are a number of schemas that supports the different modules in eBS. Everything is installed and ...
1 comment:
‹
›
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.