Showing posts with label Online Redefinition. Show all posts
Showing posts with label Online Redefinition. Show all posts
Wednesday, May 12, 2021

Simple script for finding a leftover FK constraint to an interim table after a redefinisjon

›
After a redefinition of a table, you may be stuck with some FK constraints from other tables, to the old interim tables. This simple scri...
Tuesday, March 9, 2021

How to add a different looking index to your interim table during online redefinition

›
The procedure REGISTER_DEPENDENT_OBJECT in the DBMS_REDEFINITION package lets you add a dependent object to your interim table during onli...
Wednesday, November 14, 2018

New parameter in dbms_redefinition.finish_redef_table in 12c

›
Oracle 12c adds a potentiall very useful feature to the dbms_redefinition package, in the procedure finish_redef_table: dml_lock_timeout ...
Thursday, June 28, 2018

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...
Wednesday, April 18, 2018

Potential solution for ORA-12008: error in materialized view or zonemap refresh path

›
During the synch-phase of an online redefintion, I received the error: begin ORA-42009: error occurred while synchronizing the redefiniti...
1 comment:
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 ...
Friday, April 7, 2017

How to work around ORA-12008 and ORA-01858 during an online redefinition

›
The following error occured during redefintion: Move method (cons_use_pk or cons_use_rowid): cons_use_rowid begin * ERROR at line 1: ORA-1...
Tuesday, March 28, 2017

How to redefine a table that is created with an identity column

›
You have the following non-partitioned table defined: CREATE TABLE MYTABLE ( ENTRY_SEQ_NUM NUMBER Generated as Identity ( START W...
3 comments:
Wednesday, March 8, 2017

How to partition a table using a virtual column and online redefinition

›
Consider the following table: desc DOCUMENT_SUMMARY Navn Null? Type ------------------------------...
Friday, December 11, 2015

Preparations to make before running dbms_redefinition on a large table

›
To avoid ORA-01555 "snapshot too old", you should take the following precaution before starting an online redefinition of a larg...
Thursday, February 6, 2014

Which privileges are needed to execute DBMS_REDEFINITION package?

›
Execute privileges on the DBMS_REDEFINITION package are granted to EXECUTE_CATALOG_ROLE. In addition to having execute privileges on this ...
Saturday, October 19, 2013

How to perform an online reorganization of a table - step by step

›
First, check that your user is eligeble for usage of the DBMS_REDEFINITION package. It requires generous privileges. Step 1: determine i...

The reason for "ORA-12052: cannot fast refresh materialized view" during Online Redefinition

›
Online Redefinition of an object relies on Material View (MView) logs to keep track of all data changes in the table under redefinition *whi...