Upgrade Guide › Upgrading Databases › Upgrading the Data Warehouse › Partition the New Data Warehouse Tables

Partition the New Data Warehouse Tables

(Optional)

New data warehouse tables have been added in the current version of CA DataMinder. If your data warehouse was partioned in a previous version of CA DataMinder, you must execute a procedure in the Wgn_Partition_Util core package to partition the new tables.

The following command partitions the new tables in your data warehouse. Use SQL*Plus to run this command as the schema owner:

SQL> EXEC Wgn_Partition_Util.wgn_partition_tables
  ( 
    partition_dates => WGN_PARTITION_DATES_TAB(), 
    db_type => Wgn_Partition_Util.wgn_db_type_DW,
    Partition_Options => Wgn_Partition_Util.wgn_opt_Partition_NonPart_Tabs, 
    pdebug => True
  ); 

Note: For details about the Wgn_Partition_Util core package, see the Database Storage and Partitioning chapter in the Database Guide.