Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Alter procedure auditing Oracle
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • V$transaction notes for finding XID composition. Oracle
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • How to sort list of files on basis of their sizes. Linux/Unix
  • How to analyze statspack or AWR report. Oracle
  • import-export with multiple files Oracle
  • scripts to take listener.log backup Linux/Unix
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • online_ts_bkup.sql Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • How does one SELECT a value from a table into a Unix variable? From SQL to Shell Linux/Unix
  • Exadata Basics Oracle
  • Check Oracle installed products using one command 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

  • Find All internal Parameters Oracle
  • Good RAC & Standby Notes Oracle
  • Rman Notes -1 Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Goldengate document from Porus Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) 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 (387)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (336)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024
  • Add new columns in dataframe30-Sep-2023

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • check_copy_progress.sh Linux/Unix
  • Specify the Rollback segment to use in Transaction Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • CPU speed on Linux Linux/Unix
  • DBMS_JOB all example Oracle
  • Session_info.ksh Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme