SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-01-05 14:49:25

garbuya
Member

Bug - "Tools-Generate Scripts" does not script Oracle triggers

Are there any plans to add scripting for triggers?

Offline

#2 2016-01-06 10:06:46

sqldbxhelp
Administrator

Re: Bug - "Tools-Generate Scripts" does not script Oracle triggers

Scripting for triggers is supported. Not sure why it does not work in your case

Offline

#3 2016-01-06 16:41:00

garbuya
Member

Re: Bug - "Tools-Generate Scripts" does not script Oracle triggers

I do not see triggers even in schema where I have a full access
But there are triggers there visible in SqlDeveloper
Objects

Offline

#4 2016-02-22 10:25:36

garbuya
Member

Re: Bug - "Tools-Generate Scripts" does not script Oracle triggers

The problem is that you are slecting objects only from SYS.ALL_xx

I emailed your support a solution - union select from SYS.ALL_xxx and SYS.DBA_xxx but it is still not implemented
Any plans to do it in future?
It is a very simple query change

Offline

#5 2016-02-22 15:05:20

sqldbxhelp
Administrator

Re: Bug - "Tools-Generate Scripts" does not script Oracle triggers

You can check "Use DBA_* views if available" and see if it makes the difference

Offline

#6 2016-02-23 09:19:34

garbuya
Member

Re: Bug - "Tools-Generate Scripts" does not script Oracle triggers

YESSS!
I checked "Use DBA_* views if available"  and now have a full picture
Thanks a lot!!

Offline

Board footer

Powered by FluxBB