Manoj Kumar asked 1 year ago
Title : We have existing monthly partitioned event_t setup. But since transactions occurring are comparable less in month. Can we create next partitions with quarter as width?

Question :

We have existing monthly partitioned event_t setup. But since transactions occurring are comparable less in month. Can we create next partitions with quarter as width?

1 Answers
Umesh SharmaUmesh Sharma Staff answered 1 year ago

You can use the command as follows:-
partition_utils -o add -t realtime -s 04162016 -u month -q 2 -w 4 where
-o parameter is used to add or remove partitions, -t used for realtime or deferred partitions, -s for the start time of partition which is greater than current date by atleast 2 days,
-u decides if the partition is monthly,quarterly,annually,etc, -q decides the quantity of partitions to be made, -w decides the width i.e. the width of quantity mentioned in -u parameter (4 months in above case). You may also use -f option along with this command if you have data in the partiton_last partition

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.