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, November 1, 2013

Can you revoke all object privileges from a role in one go?

›

Answer: No. The closest shortcut you get is to revoke all privileges per object from a role. Example: REVOKE ALL ON SCOTT.T1 FROM TEST...

Thursday, October 31, 2013

How to add a sleep statement to your pl/sql programs

›

Humans will often need some time to react to the output from your scripts. To briefly "pause" the output from a pl/sql script, add...

How to enable tracing for a session

›

To enable trace for a session: execute dbms_monitor.session_trace_enable(session_id => 127, serial_nu...

Syntax for using the dbms_stats.gather_table_stats and gather_schema_stats procedures

›

To use the default options: BEGIN SYS.DBMS_STATS.GATHER_TABLE_STATS ( OwnName => 'SCOTT' ,TabName =...

Wednesday, October 30, 2013

How to create a DDL trigger in a schema

›

CREATE TABLE AUDIT_DDL ( d date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), owner...

How to print the predefined error messages in the error number in pl/sql

›

dbms_output.put_line(sqlerrm(sqlcode));

Tuesday, October 29, 2013

How to set the current schema in a session

›

alter session set current_schema=SCOTT; The CURRENT_SCHEMA parameter changes the current schema of the session to the specified schema. S...

‹

›

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