Generating Reorg script on a tablespace by using (tablespace | utilities | reorg). The tool generates following script with the keyword ‘SORTDATA NO’. Toad should generate this keyword when the user is trying to reorg tablespace with ‘SHRLEVEL CHANGE’
Getting the following error when trying to run the script:
"KEYWORD OR OPERAND 'SORTDATA NO' INVALID WITH 'SHRLEVEL CHANGE'"
Defect his been address in Toad 6.0.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center