When running the script oracle_create_schema.sql to create an external Oracle database the following error occurs:
"SP2-0027: Input is too long (> 2499 characters) - line ignored
CREATE INDEX i_toma_end_time ON temp_metric_oma_aggregate (end_time)"
Create index statement is too long.
The statements were created automatically by using the Java hibernate libraries. These libraries are joining SQL statement into one single line.
There are 3 options to solve the issue:
A. Use the Foglight installer to create the FMS database schema
B. Use another tool like Toad to run the scripts
C. If SQL*Plus has to be used, run the attached script oracle_create_schema_new.sql instead of the original one oracle_create_schema.sql.
