This content has been marked as final. Show 2 replies
you can read about this in the manual (http://docs.oracle.com/cd/E11882_01/text.112/e24436/csql.htm#i997677). The manual says: "Each partition of a locally partitioned index can have its own type of sync (ON COMMIT, EVERY, or MANUAL). The type of sync specified in master parameter strings applies to all index partitions unless a partition specifies its own type." So it is possible to set for each partition its own sync type. This is possible with an ALTER statement:
1. With the above alter you can change it
ALTER INDEX index_name MODIFY PARTITION partition_name PARAMETER (paramstring)
2. You can put a partition to MANUAL and then synchronize when necessary.
So if you know when the partition needs to change, you can change it possible with another job or procedure.
Herald ten Dam
I was thinking of writing a routine that would check in the CTX_USER_PENDING view for partitions that are not in the current week and then run the dbms_scheduler job for the partition(s). In my case the partition naming is standard so I can get the partition and job for a given date.