How to run ctx_ddl.sync_index?

Asked by Black Baron William

Report
in progress 105
6 Answers 200 views

Leave a reply to Black Baron William : run ctx_ddl.sync_index


Answers ( 6 )

  1. Furious Adam

    Oracle Text Examples. by Jeff Hunter, Sr. Database Administrator. (...) You can set CTX_DDL.SYNC_INDEX to run automatically at regular intervals using the …
    Read More

    Ratings : 51 %   

      
  2. Sarah

    ctx_ddl.sync_index help[oracle] I can't seem to find any docs on this, (...) What index name should I run ctx_ddl.sync_index on? GLOBALINDEXEDBLOB_I??
    Read More

    Ratings : 20 %   

      
  3. Abbot Charly

    /* time limited sync */ ctx_ddl.sync_index(idx_name =>'RIO$'||idxid (...) Run this procedure as the last step when recreating a local partitioned index online.
    Read More

    Ratings : 74 %   

      
  4. Moug

    Kana is telling our developer that we need to run begin ctx_ddl.sync_index('kc_ctx_rawtext', '12M'); end; to resync the text index.
    Read More

    Ratings : 63 %   

      
  5. Nathanael

    this is in pkg_job_call, when i run the following (...) insufficient privilege to access object CTXSYS.CTX (...) to execute ctx_ddl.sync_index from
    Read More

    Ratings : 68 %