SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-03-25 17:06:24

timeco
Member

Trigger scripting duplicates shema name

Hi, I noticed the duplication of shema name when trigger was created using notation with hyphens like this:  CREATE OR REPLACE TRIGGER "HR"."update_job_history_"
So when you right click and script this trigger, the result is:  CREATE OR REPLACE TRIGGER  "HR".HR."update_job_history_"

The reason for this is (I persume) DESCRIPTION column of ALL_TRIGGERS system view which looks like this, since the OWNER column is also applied to the trigger script:
2z6cwmq.png

Thanks

Goran

Offline

Board footer

Powered by FluxBB