Please use the query below to identify and provide the SID and Serial#. col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_seen, MAX(sample_time) AS last_seen FROM…
Read MorePlease follow the below steps. Prerequisites Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS is healthy before making changes. …
Read MorePlease use the below query to get the output. set echo on; SELECT COUNT(*) AS object_priv_count FROM dba_tab_privs WHERE grantee = ‘A’; set echo on; SELECT COUNT(*) AS role_grant_count…
Read MorePlease execute the below and change the username accordingly. After the trace drop the trigger. CREATE OR REPLACE TRIGGER “1234_TMP_LOGGINGTRIG” AFTER LOGON ON DATABASE begin if ora_login_user = ‘1234’…
Read MorePlease find the below steps to enable the same. create audit policy audit_all actions all only toplevel; audit policy audit_all by user1,user2,user3; audit policy audit_all by sys,system; CONNECT /…
Read MorePlease run the below query to get the output. SELECT owner, table_name, column_name, generation_type, identity_options FROM dba_tab_identity_cols ORDER BY owner, table_name; Generation type is below. GENERATED ALWAYS AS IDENTITY…
Read MorePlease use the below query to generate the script and run accordingly. Public Synonym: ——————– select ‘create or replace public synonym ‘||table_name||’ for ‘||owner||’.’||table_name||’;’ from dba_tables where owner=’QA’; …
Read MorePlease run the below and do the export again. create index SYS.IMPDP_STATS_1 ON SYS.IMPDP_STATS (c5,type,c1,c2,c3,c4,statid,version);
Read MorePlease follow the below steps to delete the same. cd $ORACLE_HOME/OPatch ./opatch util listorderedinactivepatches -silent ./opatch util deleteinactivepatches -silent ./opatch util listorderedinactivepatches -silent
Read MoreIf a point-in-time recovery is not an option, follow the steps below: Backup the Database as sys user. We will have to patch fed$apps and obj$. startup restrict; Create backup…
Read More