create index based on another index
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Wed, 14 Dec 2022 16:43:57 +0200
Message-ID: <CA+riqSX6BLbJfCf7T_bh7VAJjzsf4v-yikooP8tgw4ZuxWYYcg_at_mail.gmail.com>
Hello,
Date: Wed, 14 Dec 2022 16:43:57 +0200
Message-ID: <CA+riqSX6BLbJfCf7T_bh7VAJjzsf4v-yikooP8tgw4ZuxWYYcg_at_mail.gmail.com>
Hello,
I have a situation where an index on a single column is too big (around 25TB) and needs to be partitioned. The plan is to create another index (global partitioned by hash) on the same column, invisible, then drop the other non-partitioned index and make the partitioned index visible.
Thanks (and sorry if sounds like a stupid question)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 14 2022 - 15:43:57 CET