Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • Exadata Basics Oracle
  • Read CSV file using PySpark Python/PySpark
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Search and Replace vi editor command. Linux/Unix
  • Remove duplicate rows from table Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • find the files that are 1 day old. Linux/Unix
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • on IBM-AIX for display Linux/Unix
  • TRUNCATE Privs Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • import-export with multiple files Oracle
  • scripts to take listener.log backup Linux/Unix
  • Unix split command to split files Linux/Unix

database trigger failing

Posted on 27-May-2009 By Admin No Comments on database trigger failing

Normal triggering events doesn’t succeed when corresponding triggers fails.

But there is EXCEPTION for STARTUP events: STARTUP events succeed even if the trigger fails.

There are also exceptions for SHUTDOWN events and for LOGON events if you login as SYSTEM

Oracle, SQL scripts

Post navigation

Previous Post: How can I tell if ASO is installed ?
Next Post: Privilege to describe the table.

Related Posts

  • Oracle GoldenGate lag monitoring shell script Linux/Unix
  • Roles and Stored Procs II Oracle
  • Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • pvm_pre_change.sql Oracle
  • sid_wise_sql.sql Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Very clear article about oracle dataguard Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • upload.html PHP/MYSQL/Wordpress
  • copying/removing directory with all its subdirectory Linux/Unix
  • Monitor and Trace Unix processes using truss Linux/Unix
  • newupload.html PHP/MYSQL/Wordpress
  • Good RAC & Standby Notes Oracle
  • ORA-4031 issue and solution on 09-MAY-2008 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme