On 02/09/2016 05:10 PM, Chen Zhou wrote:
How long should we expect to redefine 300GB BLOBs? A few hours or a few days? Can it end up hanging?That depends on your configuration and IO performance. There is a definite difference in doing things on a high end AIX box, accessing VMAX or XtremIO array or a Dell box accessing a JBOD device.
Can I take the opportunity to move the BLOB to another tablespace during this redefinition process?
Thank you for your information.
Chen