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.

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

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.

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

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...