Increasing partitions and creating partitions
From: Balwanth B <balwanthdba_at_gmail.com>
Date: Thu, 29 Sep 2016 09:35:50 -0400
Message-ID: <CAL72EnBg0Mqi4wEJxmjv6mF4r4MwgzdsbUy_GWCTPC05QNbU8g_at_mail.gmail.com>
Hello everyone,
Date: Thu, 29 Sep 2016 09:35:50 -0400
Message-ID: <CAL72EnBg0Mqi4wEJxmjv6mF4r4MwgzdsbUy_GWCTPC05QNbU8g_at_mail.gmail.com>
Hello everyone,
Need your suggestion on below
Version 11.2.0.4
We are having 10 production database tables with millions of records( biggest one is 450 million records... highly transaction databases).. some tables are already partitioned( now we have to increase the number of partitions up to 1024 partitions) and few are UN-partitioned... All this tables have referential integrity between them and some other tables which are not in this 10 tables.. can you please advice me what is best practice to increasing number of partitions or creating the partitions for existing tables... Totally new to partitions..
Your suggestions will be much helpful?
Thanks,
Bobilli
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 29 2016 - 15:35:50 CEST