Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, raja.
Asked: September 09, 2020 - 4:53 am UTC
Last updated: September 09, 2020 - 10:41 am UTC
Version: 12c
Viewed 1000+ times
create table t ( c1 int, c2 int, c3 int ); create index i1 on t ( c1 ); create index i2 on t ( c2 ); create index i3 on t ( c3 ); alter table t modify partition by range ( c1 ) interval ( 100 ) ( partition p0 values less than ( 101 ) ) update indexes ( i1 local, i2 global, i3 global partition by hash ( c3 ) partitions 4 ); select index_name, partitioned from user_indexes where table_name = 'T'; INDEX_NAME PARTITIONED I1 YES I2 NO I3 YES select index_name, partition_name from user_ind_partitions; INDEX_NAME PARTITION_NAME I1 P0 I3 SYS_P2660 I3 SYS_P2661 I3 SYS_P2662 I3 SYS_P2663
Rajeshwaran, Jeyabal, September 09, 2020 - 11:10 am UTC
If you are new to partitioning, check out Connor McDonald's introduction series here.
Documentation set on VLDB and Partitioning.