Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Global non-prefixed partitioned index support oracle 11g/12c

user12075620Sep 27 2017 — edited Sep 28 2017

The oracle documentation states that

"Oracle does not support global nonprefixed partitioned indexes"

I could able to create the global partition index on this table.. Here is the small test case

SQL> create table t ( x int, y int, z int )

  2  partition by range(x)

  3  (partition p1 values less than (1),

  4  partition p2 values less than (2),

  5  partition p3 values less than (3)

  6  );

Table created.

SQL>

SQL>

SQL> create index idx_t on t(y) global;

Index created.

Please help me to understand the concept in a better manner.

This post has been answered by Hemant K Chitale on Sep 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2017
Added on Sep 27 2017
17 comments
923 views