Creating Table Partitions for an Oracle Database

To create table partitions for an Oracle database, follow the instructions in this section.

To run the partition-creation script:

1.

Stop the FlexNet Manager for Engineering Applications Admin and Reporting servers, if they are running.

2.

Open the script file, located at the following location:

<reporting_install_directory>/site/samples/db/PartitionNonPartitionedTableOracleFinal.sql

3.

Assign the “dba” role to the FlexNet Manager for Engineering Applications Reporting database user. This role can be removed after the script has been executed.

4.

Connect to the FlexNet Manager for Engineering Applications Reporting database using SQL*Plus or SQL Developer, then copy and paste the contents of the script into the SQL client.

5.

Execute the complete script.

6.

Review the output to check for any errors.

7.

Start the FlexNet Manager for Engineering Applications Reporting and Admin servers.