I have a developer that is creating some tables thru TOAD that have a identifier column. When he does this, the script puts the keyword 'noscale' in the sql. The SQL fails and then he removes the 'noscale' and reruns successfully.
Is there a place in TOAD where you can tell it not to put that keyword in there?
Here is the SQL and error message:
CREATE TABLE TRREPORTING.DOCUMENT_SALLIETEST
ID NUMBER GENERATED ALWAYS AS IDENTITY ( START WITH 289491 INCREMENT BY 3 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CYCLE CACHE 20 ORDER KEEP NOSCALE) NOT NULL,
FILENAME VARCHAR2(255 BYTE) NOT NULL,
APPLICATION_ID NUMBER NOT NULL,
DOCUMENT_TYPE_ID NUMBER NOT NULL,
DESCRIPTION VARCHAR2(200 BYTE),
TIMESTAMP DATE DEFAULT SYSTIMESTAMP,
USER_NAME VARCHAR2(254 BYTE)
Error at line 3
ORA-02000: missing ) keyword
Has anyone else run into this?