When rebuilding a table in Toad, it ignores the 'owner name Never Include' flag, and the owner name is included twice in the trigger script - owner.owner.name_of_trigger
Steps to Replicate:
- open Toad
- set object loading option to Never Include
- check the triggers tab on the table, which shows the object name
- Use the Rebuild option on the table and go to the SQL tab
- Scroll down in the script until you get to the trigger - the script shows the schema name twice.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center