Please 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 MorePlease use the below query. set lines 132 col waitevent head EVENT format a5 trunc col username format a10 col osuser format a10 trunc col p1 format 9999 col…
Read MorePlease follow the below steps to delete all the latest inactive patches using the following command. One inactive patch remains, to allow the current patch to be rolled back. cd $ORACLE_HOME/OPatch . /opatch util deleteinactivepatches…
Read More