Toad for Oracle 12.12.0.39. Oracle documentation shows that the KEEP/NOKEEP option is valid for a sequence object but is not one of the options in the identity clause for CREATE TABLE columns. If you create a table with an identity column, Oracle creates a random name sequence object and ties that to the column. Problem I am running into is Toad appears to be adding in the KEEP/NOKEEP option setting to the CREATE TABLE script available through the Schema Browser. If you try to run that script, you get an error due to this inclusion.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| TOAD Editor rejects Identity column KEEP syntax created in Schema Browser | 0 | 1070 | May 4, 2018 | |
| Schema Compare - Identity Column | 5 | 1668 | September 6, 2018 | |
| cannot generate identity tables | 16 | 2629 | July 1, 2013 | |
| Toad for Oracle v12.0.7 create table scripting constraints generated together instead of by themselves | 1 | 633 | August 13, 2015 | |
| Issue with create table script and not nulls | 5 | 2975 | February 7, 2017 |