Seeing ORA-00922 errors within the management server log files where creating obs

Seeing ORA-00922 errors within the management server log files where creating obs_ tables (148215)

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Seeing ORA-00922 errors within the management server log files where creating obs_ tables
Description

Within the Managenent server log files the Oracle error ORA-00922 messages appear when creating any obs_ tables.
Cause

This issue is being caused after incorrectly following details within KB 127614.
Resolution

Within the storage-parameters.config.cfg file under $FGL_HOME\config the word OVERFLOW should only be on the aggregate-iot & scalar-iot entries.
"obs_metric_aggregate" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)",
"obs_metric_scalar" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)",
"obs_string" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)",
"obs_binary" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)",
"obs_metric_aggregate-iot" : "ORGANIZATION INDEX COMPRESS 2 ${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED) OVERFLOW ";
"obs_metric_scalar-iot" : "ORGANIZATION INDEX COMPRESS 2 ${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED) OVERFLOW";