Oracle DBA, How To, Error, Cause and Action

ORA-01771: illegal option for a clustered table

ORA-01771: illegal option for a clustered table


Cause:


During a CREATE or ALTER of a clustered table, the user attempted to enter one or more of the following options: INITRANS, MAXTRANS, PCTFREE, PCTUSED, STORAGE, TABLESPACE. These options may only be specified for the cluster itself.



Action:


Remove the illegal option(s).

No comments:

Post a Comment

Thanks for your comment.