ORA-00974 : invalid PCTFREE value (percentage)

Email This Post Email This Post

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.

Popularity: 2% [?]

Related Post

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Close
E-mail It