When a snapshot, whose name length is greater than 18 characters, is created with a rowid index, the script generated by Toad has "With Rowid" and "Create Unique Index..." statements in it.
This script will error out with an "ORA-00955: name is already used by an existing object" because the "With Rowid" statement creates the Unique Index and then when the "Create Unique Index" is executed it is trying to create an object that already exists.
WORKAROUND:
1. Shorten snapshot name to less than 19 characters.
2. Delete Create Unique Index Statement from script before running.
STATUS:
Issue fixed in version 9.5.0.31. The latest version of Toad for Oracle can be downloaded here.
