Database Administration (MOSC)

MOSC Banner

Set PCT_FREE on IOT table in version 12c

edited Sep 13, 2018 10:53PM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi all,

I run the below DDL statement to set PCT_FREE to 5 for some IOT tables in oracle version 12c:

alter table SYS_IOT_OVER_92129 MOVE PCTFREE 5;

But received the below error:

SQL Error: ORA-25191: cannot reference overflow table of an index-organized table

25191. 00000 -  "cannot reference overflow table of an index-organized table"

*Cause:    An attempt to directly access the overflow table of an

           index-organized table

*Action:   Issue the statement against the parent index-organized table

           containing the specified overflow table.

I also found the IOT name for this table from all_tables. But their's PCT_FREE is zero (0). I know that the default value of PCT_FREE is 10, but don't understand why is the value of IOT name is zero. Are there problems if I set PCT_FREE of these IOT name tables to 5?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center