Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Reusing masterkeys in TDE once reset

    Hi Team We are implementing a change data capture setup in our environment where the source database has TDE in place. The encryption is performed using oracle key management and we would want to know till how long the old masterkey will be valid once after we reset the masterkey...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ASM error: ora-59700

    Hi Tom, when I try to add two new disk , once for failgroup , I receive this error: ALTER DISKGROUP OCR ADD FAILGROUP FGA disk '/dev/oracleasm/disks/pippo_OCR1_A_alfa' NAME pippo_OCR1_A_alfa FAILGROUP FGH disk '/dev/oracleasm/disks/pippo_OCR1_H_alfa' NAME pippo_OCR1_H_alfa REBALA...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    APEX_WEB_SERVICE.MAKE_REQUEST ORA-29270: too many open HTTP requests

    Hi, I am using APEX_WEB_SERVICE.MAKE_REQUEST instead of utp_http package to consume rest api calls. Is there are way to close APEX_WEB_SERVICE.MAKE_REQUEST similar to UTL_HTTP.END_RESPONSE? I am getting ORA-29270: too many open HTTP requests (more than 5), need to call the api du...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Many BLOB fields in table

    Hi Tom, Is it advisable to have more BLOB fields in a table? (Planning to have 20), Each BLOB field will be stored with small amount of data per row. table may have 1.5 million rows. what will be disadvantages (if any) if we have more BLOB fields in a table.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Bad dates in table like 00-000-0000

    We have a table with an END_DATE column defined as Column_Name Data_Type Nullable Data_Default END_DATE DATE Yes (null) During the period of 24-oct-2007 07:36:04 to 23-sep-2019 11:41:41 a number (but not all) of the rows have a dump century of
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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