In SAS Fraud Management, to change partition granularity from weekly to daily for the Oracle Database, complete the following steps for each table.

Note: SAS recommends that you back up the DDL from the tables, as well as the data from the FMX_PARTITION_DEFINITION table, before completing these steps.

To reverse this change, set the values back to their original state (that is, what they are now).

1. Alter the table to the new partition granularity. The generic alter statement is as follows:
   

   
   ALTER TABLE <table name>

       set INTERVAL(numtodsinterval(1, 'DAY'));
   
   For example, if you want to alter the Credit Card Account Authorization table (CCCA), the statement would look similar to the following:

   
   ALTER TABLE 'FCM_CCCA'

          set INTERVAL(numtodsinterval(1, 'DAY'));
   
   

2. Update the SAS Fraud Management application to use the new granularity. Run the statement below for each table:
   

   
   UPDATE fmx_partition_definition

   SET

          granularity = '1',

          granularity_unit = 'INTERVAL(NUMTODSINTERVAL(1, ''DAY''))'

   WHERE

          table_name = <table name>;
   
   For example, to update the CCCA table, the statement would look similar to the following:

   
   UPDATE fmx_partition_definition

   SET

          granularity = '1',

          granularity_unit = 'INTERVAL(NUMTODSINTERVAL(1, ''DAY''))'

   WHERE

          table_name = 'FCM_CCCA';