The DBA Advisor recommends to shrink some tables such as SXMSCLUP (where a lot of data has been removed). So we performed a test of the process using BRTOOLS in a development environment successfully.
We then discovered the above note which states that tables with long raw cannot be shrunk and yet SXMSCLUP contains an lraw field. Note 910389 hasn't been updated since 2007 so is it out of date for Oracle11g?
We are using Oracle 11.2.0.3 with the September SBP along with brtools 720 patch level 25.
Please advise if we can use the shrink function of brtools on such tables and if we can will note 910389 be updated to reflect this change?
Regards,
Deepthi