Question : I have the following table that I want to redefine: create table tq84_redefinition ( id number primary key, […]
Tag: dbms-redefinition
Oracle dbms_redefinition fails with ora-01749, why?
Question : I ran this as a part of redefining a table DECLARE l_num_ers PLS_INTEGER; BEGIN DBMS_REDEFINITION.copy_table_dependents( uname => ‘myuser’, […]
Package DBMS_REDEFINITION missing from Oracle 11g?
Question : I’m trying to partition an existing table in Oracle and the research I’ve done seems to say that […]
Oracle dbms_redefinition fails with ora-01749, why?
Question : I ran this as a part of redefining a table DECLARE l_num_ers PLS_INTEGER; BEGIN DBMS_REDEFINITION.copy_table_dependents( uname => ‘myuser’, […]
DBMS_REDEFINITION with WHERE clause
Question : I wanted to know if DBMA_REDEFINITON package allows a WHERE clause to filter contents before migration. I have […]
Feasibility of Partitioning existing tables with huge data in Oracle
Question : We have a set of 24 tables that take up about 1tb+ data which is why DBA suggested […]