Oracle database error code ORA-00974 – invalid PCTFREE value (percentage)

Oracle Database Error Code ORA-974 Description :
invalid PCTFREE value (percentage)
Error 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.

How to Solve :
Specify a PCTFREE value between 0 and 100. Then retry the statement.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
1 Comment   
«
»