This discussion is archived
4 Replies Latest reply: Nov 20, 2012 2:57 PM by Vorlon1 RSS

restarting table redefinition

Vorlon1 Newbie
Currently Being Moderated
Have large table that needs partitioning.
Created interim table that with appropriate partitioning information.
I ran dbms_redefinition.can_redef_table successfully.
initiated the dbms_redefinition.start_redef_table command...
This ran for *33:27:49.64* and failed when one tablespace ran out of space. (ARRGGGG)
I read that I needed to abort the (pending) processing before I could do anything, so
I ran the dbms_redefinition.abort_redef_table command.
I then tried running the dbms_redefinition.sync_interin_table command, and got
'invalid interim table'
Is there a way to restart without truncating my interim table?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points