Skip to Main Content

Ask The Oracle Mentors

Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Restore and Recover with no backup noarchivelog mode

    Hi team, I have a database which is in no archivelog mode and NO Backup like rman and cold backup are available. Only logical Backup (export schema) is available. And suppose one datafile is corrupted or dropped like rm then how can i restore and recover the database or datafile ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    REST request not allowed on Autonomous DB

    Hi folks, I would love to have the JSON from the following REST request: https://sgx.geodatenzentrum.de/geoserver/vg250-ew/wfs?service=wfs&version=2.0.0&request=GetFeature&typenames=vg250-ew:vg250_sta&outputFormat=json&srsName=urn:ogc:def:crs:EPSG::4326 This works fine with my
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Bind variables in calls to stored procedures

    I'm using Oracle 19.28, oracles 3.3.0 and python 3.9.20. What are the rules for using bind variables (either positional or named) when calling a stored procedure using oracles ? Additionally where can I find a complete list of DPY error codes from oracles ?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Sql Plan Baseline

    Hi Dear Experts, I want to create a SQL PLAN baseline for one of the My system query in a two-node RAC 19.21. With user SYS and inside a PDB with the following commands var v_num number; exec :v_num:=dbms_spm.load_plans_from_cursor_cache(sql_id => '0b3...............',plan_hash_v...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    DBMS_FILE_TRANSFER.PUT_FILE multiple "source_file_name"

    Hi I am using Datapump to export dump file from a database and while exporting the dumpfile, I am splitting that dumpfile into multiple files. Now I want to transfer those files to another server using DBMS_FILE_TRANSFER.PUT_FILE. I know I can explicitly mention the file names in...
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report