Oracle Text domain indexes in a separate tablespace?
The text indexes are created by a packaged application, so I cannot easily change the code. I may change the default tablespace for the schema owner, but do not want to do that.
The Application uses a preference when creatring the indexes, and I can change the prefence by setting the parameters i_index_clause, r_tacble_clause and so on.
This works almost as expected. All objects (segments) for each index are now created where i want them, execpt for one.
The preference setup:
Ctx_Ddl.Create_preference('INDEX_STORAGE', 'BASIC_STORAGE');
-- added to specify tablespace, ref. Oracle Text Reference 12c Release 1 (12.1.0.2), section BASIC_STORAGE Attributes