ALTER TABLE MOVE UPDATE INDEXES - Oracle 12.2.0.1.0

Toad for Oracle - Beta
1

In the Toad editor, specifying 'UPDATE INDEXES;' in an "ALTER TABLE MOVE" statement is highlighted as an error (please see attached). When the statement is executed the statement execute successfully (please see attached).

2020-09-24 08_09_20-Greenshot
2020-09-24 08_09_20-Greenshot1920×1080 257 KB
2020-09-24 08_09_00-Greenshot
2020-09-24 08_09_00-Greenshot1920×1080 194 KB

2

Hello,

Would it be possible to pass me the problem statement(s) in text format? If it is somewhat confidential then you can email me on andre.vergison@q...t.com .

Thanks,
Andre

3

Please see the attached.

problem_sql.sql (132.0 KB)