Oracle 11.2.0.4 Using DBMS_REDEFINITION to Reorg 2 Lobs in the same table with DG primary and 2 Stby
I tried the following but it filled up the arch dest on the primary and hung the db:
Is it better to use the ALTER TABLE_ MOVE LOB or DBMS_REDEFINITION ? Would adding an ALTERNATE or a completely different arch destination in Primary and the 2 Standbys be better for ALTER TABLE MOVE LOB (then switch back after the MOVE) or would turning off the archive log shipping to the 2 Standbys be better during the MOVE then turn on after completion ? Not sure if the DBMS_REDEFINITION is the better route.
These are BASICFILE LOBs, not looking to change to SECUREFILE LOBS.