Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Package gets invalidated when adding procedure to dependent

    I have a misunderstanding related to invalidating a spec package. I create 2 package spec. create or replace package pkg_1 as function f_1 return number; end; / create or replace package pkg_2 as v number := pkg_1.f_1; end; / When checking, both of them are valid.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Trying to restore a deleted record

    I'm running this query select * from DOC_MANAGEMENT.project AS OF timestamp to_timestamp('20241002','YYYYMMDD') where project_id = 179121; And I get this error ORA-01555: snapshot too old: rollback segment number 11 with name "_SYSSMU11_2808613384$" too small
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to connect SQL Developer using oracle wallet external password store

    Hi, How can i connect to SQL developer using oracle wallet based security. from sql plus we can connect using the command like /@sid, but how can i connect to SQL developer (or) toad using the wallet based security. Thanks in advance.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    MONTHS_BETWEEN function logic

    I am trying to understand how oracle calculates months_between. Here is the query: SELECT MONTHS_BETWEEN(to_date('07/17/2027','mm/dd/yyyy'),to_date('06/22/2027','mm/dd/yyyy')) "Months" FROM dual; This returns: 0.8387096774193548387096774193548387096774 The duration is 25 Days. T
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Rman backup incremental level 1 for recover of copy with tag

    I have done some searching on the web with documentation saying when running incremental level 1 for recover of copy backup may need to turn block change tracking on to avoid performance issue. Currently we are having the block change tracking as disabled. However, we did raise o...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report