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, June 29, 2018

Overview over archivelogs present in the FRA

›
The following query reveals that my FRA contains archived logs from the last 3 days only (indicated by an "A" - available). --...
Thursday, June 28, 2018

How to solve ORA-00069: cannot acquire lock -- table locks disabled

›
Unfortunately, the only known way out of this is to 1. stop the database 2. start in restricted mode with "startup restrict" 3...

How to fix ORA-02449: unique/primary keys in table referenced by foreign keys after an online redefinition

›
When attempting to drop the interim table after a successful online redefinition, you may get: ORA-02449: unique/primary keys in table r...

How to solve ORA-14024 during execution of DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS

›
Background: you are redefining a table and have successfully completed the DBMS_REDEFINITION.START_REDEF_TABLE procedure. As you are exe...
Monday, June 25, 2018

How to move data using Transportable Tablespaces

›
Mission: * Move schema FXMART with all of its data from source database proddb01 to destination database testdb01 * In the same operati...
Thursday, June 21, 2018

What is the meaning of INCREMENTAL_STALENESS in dbms_stats?

›
INCREMENTAL_STALENESS means "how we decide if a partition's statistics are stale". Its values can be either USE_STALE_PERC...
Wednesday, June 20, 2018

How to solve ORA-55622 during DROP USER ... CASCADE;

›
During a DROP USER ... CASCADE operation, you may encounter the following error: ERROR at line 1: ORA-00604: error occurred at recursive ...
‹
›
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.