Is it possible to specify the tablespace for the primary key index when the primary key is created like this:
CREATE TABLE AST_EU
(
AST_EU_ID NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY CONSTRAINT AST_EU_PK PRIMARY KEY,
REQUEST_ID VARCHAR2(50 BYTE) NOT NULL
);
When running the create table statement above, the primary key index AST_EU_PK is created in the default tablespace DATA01. However, we would like to have it created in a tablespace named INDEX01.