When a script is created for a user creation from an existing database, when selecting a single user, the script contains the synonyms creation statements but if you select multiple users (with the same options), the script generated does not contain the synonyms creation part.
Steps to replicate:
1. Go to Schema Browser | Users Tab 2. Select a user which owns at least one private synonym 3. Click “Create script”. Private synonym is included in script. 4. Go back to Schema Browser | Users tab. 5. Select two users and create the script
There are no synonyms created.
原因
Product Defect - TOR-8194
解决办法
WORKAROUND: None
STATUS: Waiting for fix in a future release of Toad for Oracle.
Issue fixed in Toad for Oracle 2024 R2 - v24.2.275.4664 (Released on Nov 4th 2024).
The latest version of Toad can be downloaded here:
