Tag Archives: ORA-00974

ORA-00974: invalid PCTFREE value (percentage)

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

https://support.oracle.com/

http://www.oracle.com/