Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Clean up Oracle
  • Export Oracle data and Compress at same time Oracle
  • Convert multiple rows to single column Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • scripts to take listener.log backup Linux/Unix
  • Wait.sql Oracle
  • Oracle Identifiers Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • Goldengate Tutorial Oracle
  • temp_use.sql diplays usage of temp ts Oracle
  • fuser to check who is using diretory Linux/Unix
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • Passing from Unix to PLSQL using bind variables 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

  • DBMS_SQL for alter session. Oracle
  • Query to Generate aggregate on every 30 mins. Oracle
  • How to Modify the statistics collection by MMON for AWR repository Oracle
  • Jai Shree Ram Oracle
  • DBMS_Shared_pool pinning triggers Oracle
  • myfile 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 (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • 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.sh23-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
  • How to set Processes Parameter Oracle
  • SQL Server: How to see historical transactions SQL Server
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • Unix split command to split files Linux/Unix
  • Clean up Oracle
  • chk_space_SID.ksh Linux/Unix
  • My FTP Job Scheduling for www.pvmehta.com PHP/MYSQL/Wordpress
  • Distributed Transaction Troubleshooting. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme