Repository navigation
ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported #2039
Description
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>
Activity
manticore-projects commentedon Jul 17, 2024
Greetings,
the
ALTERstatements 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.[-]version 4.9+ Error parsing alter statement[/-][+]ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported[/+]