Database Utilities (MOSC)

MOSC Banner

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?

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