Get Ora-00953 error when running sync script from schema compare (4246421)

The following error is returned when running the sync script created from the schema compare tool.

“ORA-00953: missing or invalid index name”

Incorrect syntax is being used when renaming index.

alter index table index_name_pk

rename to index_name_pk;

WORKAROUND:
Check the “Include schema name in migration ddl” option, which can be found in the Options | Misc Options tab of Schema Compare.

STATUS:
Issue fixed in version 12.1 of Toad for Oracle. The latest version of Toad for Oracle can be downloaded at:

https://support.quest.com/toad-for-oracle