Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • cp_filesystem.sql Oracle
  • Export Import with QUERY Oracle
  • Oracle 10g Wait Model Oracle
  • move_arch_files.ksh Linux/Unix
  • Roles and Stored Object behaviour Oracle
  • send attachment from unix-shell script Linux/Unix
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • Good notes for shared pool Oracle
  • New Latest Param.sql for finding all hidden parameters also Oracle
  • FGA Part-I Oracle
  • Insert cause enqueue locks Oracle
  • xargs use Linux/Unix
  • catall.sh Linux/Unix
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • To find all disk io ( EMC as well as local) 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

  • v$backup.status information Oracle
  • lck.sql Oracle
  • Renaming the column name Oracle
  • oracle 11g RAC on vmware Oracle
  • Jai Shree Ram Oracle
  • Committing distributed transaction using commit force 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
  • checking redhat linux version Linux/Unix
  • find_open_cur.sql Find open cursorts per session Oracle
  • v$event_name Oracle
  • tblwopk.sql tablewopk.sql Oracle
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • find_idle_cpu.sql Oracle
  • Good link for LIO in Oracle ( Logical IOs) Oracle
  • Find Multiple levels of object dependencies : depen.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme