Wednesday, September 6, 2017

How to open and close a pluggable database in 12c multitenant database

›
Connect to the container database: sqlplus sys@cdbveg as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 6 13:22:57 2017 Cop...
Sunday, September 3, 2017

Solution for ORA-01442: column to be modified to NOT NULL is already NOT NULL during online redefinition

›
When trying to execute dbms_redefinition.copy_table_dependents, like this: whenever sqlerror exit set serveroutput on set feedback off set ...
2 comments:
Thursday, August 31, 2017

A workaround for ORA-12008 and ORA-14400 during online redefinition

›
To introduce partitions in one of my tables, I was using online redefinition of a rather large table. The following error was thrown after ...

How to explain a SQL statement using bind variables

›
Sometimes I am asked to analyze an SQL statement picked up from Enterprise Manager Cloud Control. These SQL statements only reveal the bind...
Wednesday, August 30, 2017

How to move a partition online from Oracle 12.1 and onwards

›
From Oracle version 12.1 and ownwards, moving partitions and subpartitions becomes non-blocking DDL operations. DML against the table can c...

What exactly is a LOB index object?

›
This question was answered by Tom Kyte in an old post from 2001. A LOB is simply a pointer. It points to an index. The index points to t...
Tuesday, August 22, 2017

How to split a default subpartition in a table using a subpartition template

›
Here is an example on how to split a subpartition utilizing a "subpartition template". Before the change, the table looked as fo...