Database Administration (MOSC)

MOSC Banner

Oracle 11.2.0.4 Using DBMS_REDEFINITION to Reorg 2 Lobs in the same table with DG primary and 2 Stby

edited Feb 26, 2025 7:45PM in Database Administration (MOSC) 1 commentAnswered

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.

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