Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.
Thanks for the question, aravind.
Asked: January 12, 2020 - 1:58 pm UTC
Answered by: Connor McDonald - Last updated: January 13, 2020 - 3:27 am UTC
Category: SQL - Version: oracle
Viewed 100+ times
Whilst you are here, check out some content from the AskTom team: Choose your names wisely
SQL> create table t as select * from dba_objects where object_id is not null;
SQL> create index ix on t ( object_id ) global partition by hash (object_id ) partitions 2;
SQL> drop index ix;
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);
SQL> create index ix on t ( fbi_col ) global partition by hash (fbi_col ) partitions 2;
January 13, 2020 - 3:57 am UTC
Reviewer: Aravind from India
If you are new to partitioning, check out Connor McDonald's introduction series here.