Axis RightFax 8.5 Guía de instalación descargar pdf (Pagina 93)

13-17

If the table is monthly, then the data is segmented as follows:

Month

Partition

Jan

partition 1

Feb

partition 2

Mar

partition 3

Apr

partition 4

May

partition 1

June

partition 2

…

If the table is weekly, then the data is divided as follows:

Week

Partition

Jan 1 –7

partition 1

Jan 8-14

partition 2

Jan 15- 21

partition 3

Jan 22-28

partition 4

Jan 29-Feb 4

partition 1

Feb 5–11

partition 2

…

Every table reuses its partitions, because the intention is that before the end of the cycle, the oldest

partition is purged in preparation for the new cycle. In other words, for a monthly table, on April 30th,

partition 1 should be purged to remove January’s data, which will then be used for May.

Truncate Jobs for Partitioned Tables

In order to make truncating the partitioned tables as seamless as possible, a script is provided that

submits an Oracle Database job to automatically purge the oldest partition, on the last day of the

cycle. These jobs should be submitted as a final step in any migration, logged in as GLOGOWNER.

1. Enter SET SERVEROUTPUT ON to be able to see feedback.

2. Run Exec partit.submit_job(‘WW’);

3. Run Exec partit.submit_job(‘MM’);

4. Run Exec partit.submit_job(‘Q’);

5. Run Exec partit.submit_job(‘D’);

These jobs are set to run at 1 AM on the last day of the cycle by default.

1 2 ... 88 89 90 91 92 93 94 95 96 97 98 ... 105 106

Comentarios a estos manuales

Sin comentarios

Axis RightFax 8.5 Guía de instalación Pagina 93

Comentarios a estos manuales

Relacionado con productos y manuales para Software Axis RightFax 8.5