Thanks for the question, aravind.
Asked: January 12, 2020 - 1:58 pm UTC
Last updated: January 13, 2020 - 3:27 am UTC
Version: oracle
Viewed 1000+ times
SQL> create table t as select * from dba_objects where object_id is not null; Table created. SQL> create index ix on t ( object_id ) global partition by hash (object_id ) partitions 2; Index created. SQL> SQL> drop index ix; Index dropped. SQL> create index ix on t ( object_id*2 ) global partition by hash (object_id*2 ) partitions 2; create index ix on t ( object_id*2 ) global partition by hash (object_id*2 ) partitions 2 * ERROR at line 1: ORA-30555: global index partitioning key is an expression
SQL> alter table t add fbi_col generated always as (object_id*2); Table altered. SQL> create index ix on t ( fbi_col ) global partition by hash (fbi_col ) partitions 2; Index created.
Aravind, January 13, 2020 - 3:57 am UTC
If you are new to partitioning, check out Connor McDonald's introduction series here.
Documentation set on VLDB and Partitioning.