My Oracle Support Banner

How To Create A Trigger For Dynimic Tables Created By Application On User'S Schema (Doc ID 402907.1)

Last updated on APRIL 09, 2020

Applies to:

PL/SQL - Version 9.2.0.6 and later
Information in this document applies to any platform.

Goal

How to write a ON DATABASE trigger that will file anytime a new Table is created?
When the trigger fires, it will create a new Trigger for only specific table names within the associated schema for which the Table is created.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.