Discussion List

• Need inputs to modify the query

  Answered 40 views 4 comments 0 points Most recent by christoph.hillinger Sep 4, 2026 1:08PMSQL Language (MOSC)
• Unable to retrieve columns from the CLOB datatype

  Answered 31 views 1 comment 0 points Most recent by ViswanadhK Aug 13, 2026 3:04PMSQL Language (MOSC)
• Need to extract few fields from the CLOB column

  Answered ✓ 35 views 3 comments 0 points Most recent by ViswanadhK Aug 7, 2026 6:41AMSQL Language (MOSC)
• Tier Duration

  Answered ✓ 65 views 5 comments 0 points Most recent by ViswanadhK Apr 30, 2026 5:55AMSQL Language (MOSC)
• Schema growth size per day

  Answered 82 views 1 comment 0 points Most recent by Rahul Kumar-Oracle Jul 31, 2024 3:08PMDatabase Administration (MOSC)
• No Prompt after starting sqlplus. Reason?

  Answered 43 views 9 comments 0 points Most recent by BrunoVroman Jun 18, 2024 12:35PMDatabase Install/Upgrade/Opatch (MOSC)
• ESCCHAR can't recognize "$" because it is "Obsolete"?

  Answered 39 views 2 comments 0 points Most recent by User_YCRNU Feb 20, 2024 6:44PMSQL Language (MOSC)
• Find parent node name for all the multiple child nodes using XMLTABLE in Oracle

  Question 54 views 0 comments 0 points Most recent by User_ZOE3V Jan 25, 2024 2:47AMSQL Language (MOSC)
• sqlldr error libclntsh.so.19.1

  Answered 511 views 5 comments 0 points Most recent by SureshMuddaveerappa Nov 10, 2023 8:09PMDatabase Administration (MOSC)
• Upgrading Linux OS version using Leapp

  Answered Closed 31 views 1 comment 0 points Most recent by MichaelC-Oracle Nov 1, 2023 3:17AMLinux Operating System (MOSC)
• Unix - Getting Arabic Content

  Question 1 view 0 comments 0 points Most recent by sailesh_cloudare Oct 7, 2023 9:21AMTechnology Stack - EBS (MOSC)
• Enforcing a specific hash on a specific sql id

  Answered 21 views 2 comments 0 points Most recent by Balamurugan Sivalingam Aug 4, 2023 6:23AMDatabase Tuning (MOSC)
• "Operation not permitted" on trying to change the db_recovery_file_dest parameter

  Answered 42 views 7 comments 0 points Most recent by Christian Gohmann Jun 21, 2023 9:42AMExadata General (MOSC)
• database

  Answered ✓ 1 view 1 comment 1 point Most recent by SureshMuddaveerappa Jun 15, 2023 10:28PMSQL Language (MOSC)
• Need SQL query to display Position start date and end date

  Answered ✓ 52 views 10 comments 0 points Most recent by Visu Jun 4, 2023 7:13AMSQL*Plus (MOSC)
• Windows directory fills up with tracing files when using SQL Plus to connect to database

  Answered ✓ 152 views 5 comments 0 points Most recent by Eric from CA May 22, 2023 5:30PMSQL*Plus (MOSC)
• How to get schema of public.<table name>?

  Answered ✓ 1 view 2 comments 0 points Most recent by Mr. C Apr 27, 2023 12:33PMSQL*Plus (MOSC)
• want to ‘drop database’ and recreate it without reloading oracle and or software(copyrighted)

  Answered 32 views 4 comments 0 points Most recent by SureshMuddaveerappa Mar 17, 2023 6:51PMPatch Reviews - DB (MOSC)
• v$timezone different results

  Answered 31 views 2 comments 0 points Most recent by DBASandro Mar 12, 2023 4:02PMDatabase Administration (MOSC)
• Output Result Set to .csv Format

  Answered 11 views 4 comments 0 points Most recent by Mark D Powell Nov 29, 2022 3:28PMSQL Language (MOSC)
• Can we use %ORACLE_HOME%\bin\sqlplus.exe / as sysdba before creating instance

  Answered ✓ 62 views 18 comments 0 points Most recent by Mr. C Nov 18, 2022 9:10AMDatabase Administration (MOSC)
• Problem with sqlplus.exe Instantclient 32bits v19 (all subversions)

  Answered 1 view 6 comments 0 points Most recent by Mark D Powell Nov 14, 2022 6:16PMDatabase Utilities (MOSC)
• SQLPLUS exits unusually on Windows WebLogic host

  Answered 11 views 2 comments 0 points Most recent by User_HKP4W Jun 27, 2022 12:26PMOracle Forms (MOSC)
• No fractions of seconds in TIMESTAMP column of SQL*PLus error logging table

  Answered 11 views 4 comments 0 points Most recent by SureshMuddaveerappa Jun 3, 2022 6:06PMDatabase Utilities (MOSC)
• Is it neccesary to shut down the Database instance before applying Oracle DB Patches?

  Answered 593 views 3 comments 0 points Most recent by Arsalan Dehghanisariyarghan May 4, 2022 2:00PMDatabase Install/Upgrade/Opatch (MOSC)
• ORA-00001: unique constraint

  Answered ✓ 1 view 1 comment 0 points Most recent by KayK Dec 7, 2021 6:13AMSQL*Plus (MOSC)
• ACL creation, directory location, and confusion.

  Answered ✓ 52 views 8 comments 0 points Most recent by User_HKP4W Dec 2, 2021 5:29PMDatabase Install/Upgrade/Opatch (MOSC)
• Anyone seeing anything that looks like sqlplus is not completing the EXIT?

  Answered ✓ 2 views 2 comments 0 points Most recent by Gaz in Oz Nov 25, 2021 4:20AMSQL*Plus (MOSC)
• ORA-12547: TNS:lost contact after Upgrade from 12.2.0 to 19.3.0

  Answered 73 views 6 comments 0 points Most recent by SureshMuddaveerappa Oct 15, 2021 2:52PMDatabase Administration (MOSC)
• How do i permit non-oracle Unix accounts to run sqlplus and tnsping

  Answered ✓ 1 view 2 comments 0 points Most recent by Arsalan Dehghanisariyarghan Aug 19, 2021 1:10PMSQL*Plus (MOSC)