0

I have a CREATE TABLE statement which works fine.

However, when the following is added (as the first column in the table):

CREATE TABLE my_table
(
    id NUMBER GENERATED ALWAYS AS IDENTITY,

This error is thrown:

Error report:
SQL Error: ORA-02000: missing ( keyword
02000. 00000 -  "missing %s keyword"

What is wrong?

Thanks

user1052610
  • 4,440
  • 13
  • 50
  • 101
  • 3
    That syntax isn't supported until Oracle 12c. – Alex Poole Aug 20 '15 at 12:53
  • 1
    What is wrong? - Wrong Oracle version: check the manual for Oracle 11: http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_7002.htm#CEGEDHJE there is no `identity` in there –  Aug 20 '15 at 12:55

0 Answers0