When using the schema generation via Database|Export|generate schema script, the output to individual files does not use all the file extensions set for the objects in the format options. It works for some objects but not for all of them.
For example it doesn't work for grants / constraints / tables / indexes(they carry the sql extensions). The extension is sql instead of the one selected in Toad Options|Files|General .
To reproduce the problem(Toad For Oracle 9.7.2):
Go to Database|Export|Generate Schema Script
Click the Source and Output tab in the Generate Schema Script window to select the source and output options for theschema script.
Check Create Individual Object DDL Files option and select "Use file extension defined in Toad Options".
(This should use extension as configured in TOAD options : Toad will check Toad Options|Files|General and use the extension specified for SQL.)
If modified, the extension for grants / constraints / tables and indexes in Toad Options|Files|General , the files generated
will not take into account the extension. They will have the extension *.sql.
In addition, trying to change the default *.sql to *.plsql doesn't seem to work
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad For Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center