1. Global Deployment Guide
  2. Partitioning Prerequisite for Oracle Database

Partitioning Prerequisite for Oracle Database

This topic is part of Preparing Your Data for Conversion to UTC.

If you are using Oracle Database, some tables are partitioned by default, by using month (in the CREATED column). Make sure that the user running the UTC conversion utility has execute privilege on month. The following task describes how to give the execute permission to users who do not have it.

To grant execute permission

  1. Connect to the database server as the tableowner.

  2. Execute the following command:

    grant execute on month to SSE_ROLE