The Table Rebuild script from the Schema Browser does not show the correct PARALLER parameter for partitioned tables. For example, a partitioned table with this parallel parameter "PARALLEL ( DEGREE 12 INSTANCES 1 )," will show "NOPARALLEL" in the rebuild script.
Also note that the radio button "Parallel" under Table Storage option cannot be selected.
WORKAROUND:
Copy from the Schema Browser | Script tab or use the Create Script feature to get the script and edit it manually.
STATUS:
Issue fixed in version 12.1. The latest version of Toad for Oracle can be downloaded at:
https://support.quest.com/
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center