When reorganizing using online switch, the reorg failed with ORA-14132 error
[258] 05/14 08:30:10 line=56 sql=REM Table switch started.
[258] 05/14 08:30:10 line=57 sql=Whenever Error Stop;
[258] 05/14 08:30:10 line=58 sql=Whenever ORA-00054 Retry 20 Delay 60 Then Stop;
[258] 05/14 08:30:10 line=59 sql=EXECUTE QUEST_EXEC.ONLINE_SWITCH('QUEST', 'TABLE_WITH_DEP', 'QUEST', 'QUEST_SPC_TMP_163262_LRTAB', 'LR_DATA', 0);
[258] 05/14 08:30:10 OnlineSwitch(100)
[258] 05/14 08:30:10 Online switch failed with error: ORA-14132
[258] 05/14 08:30:10 ORA-14132: table cannot be used in EXCHANGE
[258] 05/14 08:30:10 AbortScript()
[258] 05/14 08:30:10 AbortScript: Aborted QSA-20391 ORA-14132 during internal SQL (os errno 2)
Any table created with "rowdependencies" is not correctly scripted and will fail using the online switch or exchange partition.
WORKAROUND
Use T-Lock reorganization on this table. The T-Lock reorganization will not recreate the rowdependencies clause on the table, but the reorganization should complete successfully.
STATUS
Enhancement request ST62617 has been submitted to Development for consideration in a future release of Space Manager with LiveReorg.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center