Discussion List

• cannot build index - ORA-01450: maximum key length (3215) exceeded

  Answered 41 views 12 comments 0 points Most recent by SolomonYakobson Jun 19, 2025 6:25PMDatabase Administration (MOSC)
• Tips on Index Rebuild with SQL Server

  Answered ✓ 21 views 2 comments 0 points Most recent by Kwan Lam Mar 31, 2025 8:10AMCNC, DB and Operating System - JDE1 (MOSC)
• DQM Serial Sync Index Program (DQM Serial Sync Index Program) kicks off after a Request is run

  Answered 11 views 2 comments 0 points Most recent by Sadeesh - Oracle-Oracle Jan 9, 2025 12:25PMCore Concurrent Processing - EBS (MOSC)
• DBMS_PCLXUTIL.BUILD_PART_INDEX and lock

  Answered ✓ 11 views 1 comment 0 points Most recent by user11973686 Jan 8, 2025 9:09AMDatabase Tuning (MOSC)
• Oracle stats and fragmentation related

  Answered ✓ 31 views 2 comments 0 points Most recent by Rahul Kumar-Oracle Oct 22, 2024 4:43PMDatabase Administration (MOSC)
• Is it possible to add an index to the 'valid_value' field in the 'serv_req_si_value' table without a

  Answered ✓ 1 view 1 comment 0 points Most recent by Adnan Mustafa-Oracle Oct 11, 2023 9:52AMMetaSolv Solution (MOSC)
• ORACLE_HOME/CTX/tmp getting filled up

  Answered 481 views 6 comments 0 points Most recent by User_46A7B Sep 4, 2023 5:42AMDatabase Administration (MOSC)
• Oracle Rebuild index while GoldenGate updates data

  Answered 142 views 2 comments 0 points Most recent by Gopal_Oracle-Oracle Aug 30, 2023 8:01AMGoldenGate, Streams and Distributed Database (MOSC)
• CTX Index synchronization fails with ORA error

  Answered 61 views 10 comments 0 points Most recent by SureshMuddaveerappa Jun 14, 2023 5:35PMDatabase Administration (MOSC)
• Online index creation on Oracle Standard Edition

  Answered ✓ 896 views 1 comment 0 points Most recent by JohnWatson2 Jun 1, 2023 2:27PMDatabase Administration (MOSC)
• functional index condition

  Answered 1 view 1 comment 0 points Most recent by L. Fernigrini Oct 13, 2022 11:41AMSQL Language (MOSC)
• Understanding the Benefit from Auto Indexing

  Answered 21 views 3 comments 0 points Most recent by Rob Clarkson Lloyd Jun 29, 2022 3:39PMDatabase Tuning (MOSC)
• oracle 11 optimizer problem : use of analytic functions prevent usage of index

  Answered ✓ 12 views 10 comments 0 points Most recent by paolocastle Apr 2, 2022 2:53PMSQL Performance (MOSC)
• Index hint.

  Answered 11 views 20 comments 0 points Most recent by Mark D Powell Mar 17, 2022 2:10PMDatabase Tuning (MOSC)
• Help for Task Review: Rebuilding Index (Newbie)

  Answered ✓ 11 views 15 comments 0 points Most recent by User_D3ZSF Jan 4, 2022 2:37PMDatabase Administration (MOSC)
• Oracle 19c SMON doesn't clears a canceled online index creation. Bug or Feature?

  Answered 125 views 3 comments 0 points Most recent by Mark D Powell Oct 6, 2021 5:28PMSQL Language (MOSC)
• How to improve performance of PAY002 - Payroll Register & PAY009 - Paysheet Report?

  Answered ✓ 31 views 7 comments 0 points Most recent by Satish-RRD Aug 19, 2021 3:57AMGlobal Payroll and Absence Management - PSFT (MOSC)
• How to drop index using XDF file ?

  Question 11 views 0 comments 0 points Most recent by Srinivasa Gadiyaram Jul 7, 2021 2:50PMEBS Customizations (MOSC)
• Difference between index type ''FUNCTION-BASED NORMAL'' and ''NORMAL''

  Answered 11 views 4 comments 0 points Most recent by Jonathan Lewis Apr 23, 2021 11:36AMDatabase Administration (MOSC)
• Why an Index becomes IDXTYP_INVLD

  11 views 13 comments 0 points Most recent by Arsalan Dehghanisariyarghan Feb 22, 2021 10:14AMOracle Text (MOSC)
• Disable and later Enable Index on table is it ok ?

  Answered ✓ 21 views 7 comments 0 points Most recent by Mark D Powell Nov 30, 2020 6:52PMSQL Performance (MOSC)
• What is the use of FirstLastPopClndIndex function

  Answered 31 views 3 comments 1 point Most recent by User730753-Oracle Jun 16, 2020 11:33PMRetail Predictive Application Server (MOSC)
• Index maintenance after large deletion

  Answered ✓ 73 views 9 comments 1 point Most recent by Mark D Powell Oct 14, 2019 10:01AMDatabase Administration (MOSC)
• While launching MRP, snapshot delete worker fails

  Answered 44 views 7 comments 0 points Most recent by VCP CONSULTANT Sep 23, 2019 6:08AMValue Chain Planning - EBS (MOSC)
• Can I add and index to the FolderFolders table?

  Answered ✓ 390 views 2 comments 0 points Most recent by Srinath Menon-Oracle Sep 4, 2019 11:35PMOracle WebCenter Content (MOSC)
• Index number of Calendar Hierarchy:Error

  Answered ✓ 96 views 4 comments 1 point Most recent by Sathyasheelan Aug 8, 2019 4:40AMRetail Predictive Application Server (MOSC)
• Embed Index on PDF output in BI Publisher

  Answered 65 views 8 comments 0 points Most recent by Samba Boddu Feb 20, 2019 8:17AMBI Publisher (MOSC)
• Does running systemdabase tracing affect performance of fast rebuild?

  Answered ✓ 991 views 2 comments 0 points Most recent by SandraTerry_540791 Feb 14, 2019 9:03AMOracle WebCenter Content (MOSC)