dbms_redefinition.redef_table - failed to cleanup interim tables
I have been using the rdbms_redefinition.redef_table to migrate and compress a lot of tables.
There are some remaining segments named REDEF$_T####. These didn't not get cleaned up after ending the redefinition process. Some of the redefinitions failed for different reasons ( snapshot too old,space constraints, presence of an identify column... ) . In most cases, oracle managed the cleanup and the tables were successfully redefined. Where can I find the mapping from the existing REDEF$_T### segment and my schema object? What's the best way to ensure that these segments are no longer needed? What's the best way to be rid of them?