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.



About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.