Database Administration (MOSC)

MOSC Banner

DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS procedure fails with ORA-01442

edited Jun 10, 2015 9:12AM in Database Administration (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center