Don't panic!

  

Cry about...
Oracle Troubleshooting

ORA-02170: FREELIST GROUPS storage option not allowed

Symptom:

Attempting to specify the ‘FREELIST GROUPS’ storage parameter generates the error:

ORA-02170: FREELIST GROUPS storage option not allowed.

Cause:

An attempt was made to specify the ‘FREELIST GROUPS’ storage option. This option may only be specified when using the ‘CREATE TABLE’ command and when the ‘ALLOW FREELIST GROUPS’ parameter is specified in the init-ora file.

Possible Remedies:

  • Set the ‘ALLOW FREELIST GROUPS’ parameter in the init-ora file.
  • Retry the statement without the ‘FREELIST GROUPS’ storage option.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.