Oracle Text (MOSC)

MOSC Banner

Does 'sync (on commit)' mean the index is updated immediately?

edited Oct 2, 2019 10:51AM in Oracle Text (MOSC) 13 commentsAnswered ✓

Good Day

Environment:  Oracle 12c (12.1.0.2) on Exadata

I have an Oracle Text domain index with the parameter ('sync (on commit)'.

Does this mean the index will be updated immediately when say a new document is added?

Here is the CREATE script:

CREATE INDEX BLDOCINDEX ON BL005_PUBLISHED_DOCUMENT(DOCUMENT_PDF)INDEXTYPE IS CTXSYS.CONTEXTPARAMETERS('sync (on commit)');

I had a user in our Test environment add a new document and then try to do a search on some key words and the search didn't return the document he had just created.

I am an Oracle Text newbie.

Are there any other reasons the document was not returned even though it contains the key words?

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