-
Title
Is there an option NOT to include the schema name (owner) in the naming convention of the script -
Description
Is there an option NOT to include the schema name (owner) in the naming convention of the script name when exporting DDL?
For example:
1. Connect to any database and go to the schema browser.
2. Select Procedures.
3. Highlight 3 procedures (hold down the CTRL key while selecting).
4. Right-click the last procedure and select "Create Script" from sub-menu.
5. In the Export DDL window, under output select the "One file per object" option.
6. Specify a directory path in the Directory field and click OK.
7. Browse to the path specified and notice all 3 procedures are named "<schema_name>.<proc_name>.prc".
Can the file be named "<proc_name>.prc" only? -
Resolution
RESOLUTION:
Toad for Oracle 9.6.1 or higher no longer includes the schema name (owner) in the naming convention of the script file created. Upgrade to at least Toad for Oracle 9.6.1 or higher to achieve desired naming convention.
The latest version of Toad for Oracle can be downloaded at:
https://support.quest.com/SUPPORT/index?page=downloads
NOTE: There is no option to toggle the schema name (owner) on or off.