How to trace a specific ORA- error that is raised and can be reproduced? We want to find the complete Oracle stack to understand the origin of this error. For example, I want to understand why datapump expdp/impdp raises: ORA-01422: exact fetch returns more than requested number of rows This time, the alert file is […]
Category: Triggers
Generate and format trigger DDL
How to format DBMS_METADATA.GET_DDL? To get a formatted definition of your DDLs, with all the semicolons and avoid lines break (Wrapped lines). Here is an example to retrieve the DDL of a triggers using the DBMS_METADATA package. For Oracle 18c / 12c / 11g / 10g: COLUMN Text FORMAT a2480 WORD_WRAPPED SET LONG 20000 LONGCHUNKSIZE […]
Dynamic Grants mgmt
— ############################################################ — # Creator: Yann Cousin — # Created: 2011/04/22 — # Name: dynamic Grants mgmt — ############################################################ — # — # Compatible: Oracle 9i 10g 11g — # — ############################################################ — # — # How to create a read only user and dynamicaly grant — # privileges to this new user: — # […]
Email Sys_context trigger
— ############################################################ — # Creator: Vincent Fenoll — # Created: 2011/04/19 — # Name: Email Sys_context trigger — ############################################################ — # — # Compatible: Oracle 10g 11g — # — ############################################################ — # — # Send an email in a trigger (here after the deletion of a — # row in a table)and display informations […]
Start stop service triggers
— ################################################ — # Creator: Cyrille MODIANO — # Created: 2010/08/20 — # Name: Start_stop_service_triggers.sql — ################################################ — # — # Compatible: Oracle 10g 11g — # — ################################################ — # — # This script creates a trigger used to — # run a scheduler job which call an external shell — # script or […]