Script generation for a re-org produced the following warning:
"Table will not be reorganized because it could not be supported by online switch."
The table has unique indexes without a shared column and therefore it is not supported for the online switch. This limitation is related to the rules Oracle uses for creating a partitioned table, and the online switch required to create a partitioned table to use exchange partition during the switch.
Oracle technical document : ID 1532277.1
Try the “online where available” option to see if the script will be generated and if it will prevent the issue from happening.
For a list of what is supported for Live Reorg, start Space Manager | go to Help menu | Contents. Look for the topic: “Reorganize Objects”; “Live Reorganizations with Reorg Manager”; “What is Supported for Live Reorganizations”.
