Oracle Text (MOSC)

MOSC Banner

Oracle Text domain indexes in a separate tablespace?

edited Jun 4, 2019 9:49AM in Oracle Text (MOSC) 13 commentsAnswered

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

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