brspace -f tbreorg cancellation

[Former Member]

Can anybody describe to me the best way to cancel a running brspace -f tbreorg command? We want to online reorg a table that is very active and feel that we may have issues with the reorg not being able to complete the reorg on time in our maintenance window. Also, the reorg may pose some performance issues with transactions and if that is the case we will have to cancel it. Any information would be helpful. Regards.

[Former Member]

Brad Goggler

DBMS_REDEFINITION.abort_redef_table (

uname IN VARCHAR2,

orig_table IN VARCHAR2,

int_table IN VARCHAR2);

This procedure cleans up errors that occur during the reorganization process.

and can also be used to abort the reorganization process any time.

Regards

Vinod