Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • oracle_env_10g_CADEV Linux/Unix
  • crontab syntax Linux/Unix
  • Oracle Connections expire_time and firewall Oracle
  • Finding locked objects Oracle
  • pvm_rbs1.sql (to collect rbs info from db) Oracle
  • MYSQL and Oracle Comparison for Oracle DBA MYSQL
  • db_status.sql Oracle
  • Query to Generate aggregate on every 30 mins. Oracle
  • Database logon trigger issue Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • My Test Case On 21-OCT-2005 Oracle

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

  • Another Tuning Article for subheap of shared pool Oracle
  • plan10g.sql good Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • Renaming Oracle Instance Name Oracle
  • export import with parameter file. Oracle

Leave a Reply Cancel reply

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

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sql23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • oracle 10g on linux Linux/Unix
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • Resolving RMAN Hung Jobs Oracle
  • newupload.html PHP/MYSQL/Wordpress
  • catall.sh Linux/Unix
  • CTAS with LONG Column for 9i and higher Oracle
  • RAC 11g with vmware Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme