How to specify tablespace for CREATE SEARCH INDEX on JSON column
All my efforts to change the default tablespace for my SEARCH INDEX get me nowhere. I'm trying to create a SEARCH INDEX on a JSON column (which I believe it's a domain index), and by default it's using the storage of the schema owner (our requirements are to keep indexes separately from the data).
When I issue below command I'm getting the error that follows:
CREATE SEARCH INDEX SCHEMA.SEARCH_IDX_NAME ON SCHEMA.TABLE_NAME (JSON_DOC) FOR JSON;
ORA-01653: unable to extend table SCHEMA.DR$SEARCH_IDX_NAME.$I by 8192 in tablespace TBSP
I tried few options with TABLESPACE with no luck: