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.