Oracle Text (MOSC)

MOSC Banner

How to specify tablespace for CREATE SEARCH INDEX on JSON column

edited Aug 31, 2021 1:26PM in Oracle Text (MOSC) 9 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center