ORA-02170: FREELIST GROUPS storage option not allowed
Attempting to specify the ‘
FREELIST GROUPS’ storage parameter
generates the error:
ORA-02170: FREELIST GROUPS storage option not allowed.
An attempt was made to specify the ‘
FREELIST GROUPS’ storage
option. This option may only be specified when using the ‘
command and when the ‘
ALLOW FREELIST GROUPS’ parameter is specified
in the init-ora file.
- 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: Brian Cryer 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.