ORA-00974: invalid PCTFREE value (percentage)

HashFlare

ORA-00974: invalid PCTFREE value (percentage)

ORA-00974: invalid PCTFREE value (percentage)
Cause: The percentage of free space specified in a CREATE INDEX statement is not between 0 and 100. A PCTFREE value of 0 means the entire block is available. The value 100 is not useful because it means that no data may be inserted. The default is 10.
Action: Specify a PCTFREE value between 0 and 100. Then retry the statement.

Back to previous menu