Discussion List

• Howto migrate table into partitioning with LOB which has 7TB

  Answered 48 views 8 comments 0 points Most recent by SolomonYakobson Nov 12, 2025 2:01PMDatabase DataWarehousing (MOSC)
• Reclaiming OS disk space after truncating partitions. Has a step-by-step process been created?

  Answered ✓ 38 views 5 comments 0 points Most recent by bobcalvin Oct 7, 2025 1:40PMDatabase Administration (MOSC)
• Select from External partiton table fails

  Answered 4 views 2 comments 0 points Most recent by BrunoVroman Sep 18, 2025 6:46AMSQL*Plus (MOSC)
• Multiple column range partitioning - what is wrong with this example?

  Answered 15 views 3 comments 0 points Most recent by SolomonYakobson Jul 28, 2025 10:34AMDatabase DataWarehousing (MOSC)
• Disbabling Contraints when Splitting partition

  Answered 33 views 3 comments 0 points Most recent by Mr. C Jun 27, 2025 8:13AMDatabase Administration (MOSC)
• what is the Query to change the initrans for hash partitioned indexes.

  Answered 22 views 2 comments 0 points Most recent by Swati Aryasomayajula -Oracle Jan 22, 2025 4:50AMDatabase DataWarehousing (MOSC)
• Initial extent size when converting to partitioned table

  Answered 27 views 9 comments 0 points Most recent by SureshMuddaveerappa Aug 20, 2024 3:25PMDatabase Administration (MOSC)
• PARTITIONING table internals

  Answered 30 views 3 comments 0 points Most recent by Anand_DBA-Oracle Jan 18, 2024 6:09PMDatabase Administration (MOSC)
• Can I create interval partition on primary and reference partition on child on a column not referent

  Answered 13 views 2 comments 0 points Most recent by SureshMuddaveerappa Oct 18, 2023 9:21PMDatabase DataWarehousing (MOSC)
• Oracle EXCHANGE PARTITION slow

  Answered 20 views 1 comment 0 points Most recent by SureshMuddaveerappa Aug 23, 2023 3:01AMSQL Performance (MOSC)
• Oracle Solaris 11 LUNs Partitioning for ASM GridDisks

  Answered 35 views 7 comments 0 points Most recent by SureshMuddaveerappa May 12, 2023 3:58AMStorage Management (ASM ACFS DNFS ODM) (MOSC)
• Can partition passwords be updated systemically?

  Answered ✓ 53 views 5 comments 0 points Most recent by David Grunwald-Oracle May 2, 2023 7:42PMHyperion Essbase (MOSC)
• drop partition update indexes

  Answered ✓ 310 views 22 comments 0 points Most recent by Kazuhiro Jan 25, 2023 11:38AMDatabase Administration (MOSC)
• 21c On-Prem DTS not working for Transparent Partition

  Answered 15 views 3 comments 0 points Most recent by David Grunwald-Oracle Jan 3, 2023 8:06PMHyperion Essbase (MOSC)
• MTL_SYSTEM_ITEMS_B Performance - any recommendations related to paritioning

  Question 6 views 2 comments 0 points Most recent by Suhasini-Oracle Sep 2, 2022 5:08PMInventory Items (APC/PLM/PIM) - EBS (MOSC)
• View won't compile after partition exchange on base table

  Answered ✓ 5 views 1 comment 0 points Most recent by JDusa Apr 8, 2022 5:34PMDatabase Administration (MOSC)
• Calculate/identify no of datafiles required for a table partition

  Answered 3 views 1 comment 0 points Most recent by SureshMuddaveerappa Jan 25, 2022 6:25PMStorage Management (ASM ACFS DNFS ODM) (MOSC)
• None-Partition Table to Partition Table conversion - Oracle 19c EE/RAC/AIX

  Answered 58 views 4 comments 0 points Most recent by Mark D Powell Jan 20, 2022 3:54PMSQL Performance (MOSC)
• Oracle table partitioning for parent child tables

  Answered 4 views 16 comments 0 points Most recent by Mark D Powell Oct 21, 2021 7:23PMDatabase Administration (MOSC)
• oracle table partitioning

  3 views 0 comments 0 points Most recent by MAG Oct 20, 2021 8:44PMDatabase Administration (MOSC)
• Table Split Partition

  Answered ✓ 3 views 5 comments 0 points Most recent by SureshMuddaveerappa Oct 17, 2021 7:25PMDatabase Administration (MOSC)
• Nodev, nosuid, noexec on mountpoints Linux OS Exadata VM

  Question 28 views 0 comments 0 points Most recent by User_9X114 Aug 23, 2021 8:01AMExadata General (MOSC)
• alter table move partition to reclaim storage

  Answered ✓ 6 views 5 comments 0 points Most recent by SureshMuddaveerappa Aug 2, 2021 1:29PMDatabase Administration (MOSC)
• modifying interval partitions

  Answered ✓ 6 views 3 comments 0 points Most recent by Jonathan Lewis Aug 2, 2021 11:28AMDatabase Administration (MOSC)
• Does Oracle support hyrbid range/list partition mixed with interval partitions?

  Answered ✓ 4 views 4 comments 0 points Most recent by Jonathan Lewis Jun 16, 2021 2:44PMDatabase Administration (MOSC)
• Table partitioning difference between environments

  Answered ✓ 2 views 23 comments 0 points Most recent by SureshMuddaveerappa May 28, 2021 5:25PMStorage Management (ASM ACFS DNFS ODM) (MOSC)
• Split Partition which have data on it

  Answered 25 views 2 comments 0 points Most recent by Jonathan Lewis Mar 18, 2021 9:54AMDatabase Tuning (MOSC)
• Disable and later Enable Index on table is it ok ?

  Answered ✓ 23 views 7 comments 0 points Most recent by Mark D Powell Nov 30, 2020 6:52PMSQL Performance (MOSC)
• Split table partition take a long time ?

  Answered ✓ 44 views 6 comments 1 point Most recent by Arsalan Dehghanisariyarghan Nov 24, 2020 2:50PMSQL Performance (MOSC)