I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job.
the proble is:
After i enable the log file option,
ctx_output.start_log('SYNC_INDEXES_JOB.TXT'); ctx_output.add_event(ctx_output.event_index_print_rowid); ctx_output.end_log;
3 log files at ORACLE_HOME/ctx/log directory are generated, SYNC_INDEXES_JOB.TXT, SYNC_INDEXES_JOB.TXT_0 and SYNC_INDEXES_JOB.TXT_1.
the problem is, ONLY SYNC_INDEXES_JOB.TXT IS OVERWRITED AFTER ONE SYNC JOB DONE AND NEW SYNC JOB START BUT NOT THE OTHER 2. that will make the size of the log files keep growing. What I want is all these log files overwritable, but not cumulate forever.
Does anyone has any idea how to do that? Is that possible?
Any answer will be much appreciated.