JSqlParser
JSqlParser copied to clipboard
ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported
Software Information:
- 4.9+
- oracle 19c
ALTER TABLE bfmcs.your_table
ADD CONSTRAINT your_table_pk
PRIMARY KEY (ID) using index tablespace your_tablespace;
net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "tablespace" "TABLESPACE" at line 1, column 88.
Was expecting one of:
","
<EOF>
<ST_SEMICOLON>
Greetings,
the ALTER statements are lacking many RDBMS specific features and need a more or less complete rewrite. I myself have very limited interest in DDL statements and so you will need to provide or sponsor an implementation to make this happen.