Skip to content

ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported #2039

Open
@LuckyLXX

Description

@LuckyLXX

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>

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions