Generated ANSI schema ddl script contains unicode Byte Order Marker
If generating a script via:
Database | Export | Generate Schema Script
1. in the Toad Options | General | default encoding "ANSI"
2. Menu: Database | Export | Generate Schema Script: Choose any Schema and choose "Create Individual Object DDL Files", so that every object has it's own file.
3. Then generate the .sql files and open one of them in the Toad Hex-Editor. You will see the whitespaces (=BOM CREATE TABLE...)
==> The whitespaces (BOM=Byte Order Marker) are placed in the beginning of the script so that it's not possible to run these scripts with SQL*Plus.
WORKAROUND:
When generating you generate them via Schema Browser (mark objects -> right click -> create script), then it works
Please create the scripts in the schema Browser via right click (mark objects | right click | create script) and generate one script per object, then it's possible to run these scripts with SQL*Plus afterwards.
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center