I am trying to move a table from test to prod.
The table contains a identity column defined as COL_PK NUMBER GENERATED BY DEFAULT AS IDENTITY
When I execute a Schema Compare then the resulting script returns MASTER_APP_FACT_DIM_ID NUMBER GENERATED AS IDENTITY. It is missing BY DEFAULT.
Is this normal behavior? Is it possible to have Toad create the script for the table with the full definition?