SqlDbx
You are not logged in.
Pages: 1
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:
Thanks
Goran
Offline
Pages: 1