Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    With clause in distributed transactions

    Hi Tom ! As there is put a restriction on GTTs: Distributed transactions are not supported for temporary tables does that mean that inline views in a query, i.e. using WITH clause, but those with MATERIALIZED hint will not work properly? If there is neither MATERIALIZED nor INLI...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Resume failed rman duplication

    I tried to duplicate source database to create physical standby database using the below command duplicate target database for standby FROM ACTIVE DATABASE USING COMPRESSED BACKUPSET SPFILE nofilenamecheck; I have a very big database size with multiple big data files. After finis...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to Update millions or records in a table

    Good Morning Tom. I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up in Rollback segment issue(s). Any suggestion...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    After Installation/Upgradation ORDS 22.2 unable to run apex

    1) Platform and Oracle version i tried. OS platform Windows 10 & windows 11 Oracle version : Oracle 18CXE , Oracle 21c XE, Oracle 12c (on Oracle Linux 7) ORDS 22.2 TOMCAT 9. 2) I tried it on oracle 18cXE and ords 21.4 to upgrade ords 22.2 but after installation and configuration ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    TIME part in CAST (value AS DATE)

    I am trying compare dates. Following SQL returns one row SELECT COUNT(1) FROM ( SELECT 1 FROM DUAL WHERE TRUNC(CAST(CAST('13-JUN-22 05.47.49.000000000 PM' AS TIMESTAMP) AS DATE)) = TO_DATE('13-JUN-22','DD-MON-YY') ); where as the same query without TRUNC returns zero ro
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more