Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    ORA-29284: file read error for a few lines

    Hi Experts, Thanks for taking the time out to ready my Question. I am receiving a file from a third party as a flat file, with different lines of different lengths. The first two characters of each line represents what data that line will have. (Please let me know how can I share...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Optimizing Recursive SQL Query Performance

    Problem Statement I am working with a large dataset (~11-12 million records), where I need to identify key out-of-stock (OOS) event dates for different products (MASTER_ID) across multiple marketplaces (MARKETPLACE_ID). Each record in the DETAILED_OOS_EVENTS table represents an O...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    XID differs for ROLLBACK TO SAVEPOINT redo logs in V$LOGMNR_CONTENTS

    Oracle Version: Docker Image container-registry.oracle.com/database/enterprise:19.19.0.0 Setup Script (to enable logminer) SELECT log_mode FROM v$database; SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; SELECT log_mode FROM v$database; ALTER DA
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ORA-01843: not a valid month

    I'm trying to follow along with the live lab 'Build a 'Doctor Appointments Made Easy' App using Oracle APEX Introduction' to get to know the new Workflows in Application Express. In Lab 9 task 6 I run into an error in the Check Appointment Fee activity: ORA-01843: not a valid mon...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Regarding the error of qcdlgcd()+75

    ========= Dump for incident 2526042 (ORA 7445 [qcdlgcd]) ======== [TOC00003] ----- Beginning of Customized Incident Dump(s) ----- Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x4] [PC:0x7FF87F3C490B, qcdlgcd()+75] The database prompts a socket error, and the above err...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report