DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS procedure fails with ORA-01442
Hi all,
I am trying to use DBMS_REDEFINITION to move tables from a smallfile tablespace to a bigfile tablespace. I'm running 11.2.0.3 on Solaris Intel_64. My basic process is:
1) Create empty interim table by doing:
CREATE TABLE table1_int TABLESPACE DATA_BFT AS SELECT * FROM table1 WHERE 1=2;
The CTAS is successful.
2) Start redefinition
EXEC DBMS_REDEFINITION.START_REDEF_TABLE(uname => 'owner', orig_table => 'table1', int_table => 'table1_int', options_flag => dbms_redefinition.cons_use_rowid);
The start of redefinition is successful (i.e. I get a message stating "PL/SQL procedure successfully completed."
3) I copy the dependent objects by running the following in an anonymous PL/SQL block