Recent content by Rich Hull

For Pref > Oracle > Options > Use..., the checkbox is not checked. For Pref > U/I > NLS > Date, the select is User Defined with a mask of DD-MMM-YYYY. MMM isn't a valid Oracle format string, but maybe that's not what is being used here. Oracle would want this to be MON. I have not recently...

When a date (such as the Start date) is displayed, it is formatted as dd-Mon-yyyy. However, when the job is updated, it expects the format to be dd-mm-yyyy. Merely clicking the date selector, and then [OK] reformats the date, and the [Apply] will then work. Also, I'm not seeing support for time...

It was not enabled. It is now, and the information is now coming through. Thanks! -R.

When connected as SYS, and looking at another user's objects (say, BILL), when you expand an object such as a view to see the "Granted to Users" node, nothing appears in that node, even though such grants exist. When connected as BILL, and similarly expanding the object browser tree, the grants...

I've noticed the same thing - not sure when this started. My work-around has been to create a trigger named ZZZ on the last (alphabetically) table in the schema. That way I don't have to deal with the last entry in the list. Not real pretty, but it works.

I would like to see a new option to ignore the current value for sequences during compare. This would eliminate some false hits for many of my comparisons, but would allow me to get true hits for more significant events (such as the creation of a new sequence). When a new sequence is detected by...

I would like an option to override the sequence starting values to an entered value (like, 1) during export. This would solve a couple of issues for me. (1) it would eliminate the need to run a little SQL script that uses dynamic SQL to reset all the sequences after an install, and (2) I...

I have also been bitten by this, but thanks for a great product.

...and a wonderful feature it is! I can't tell you how many times I've lost INSTEAD OF triggers when making changes to views using other PLSQL tools. However, the PSD "Compare User Objects" feature is not so accomodating. When it detects a difference in the view, it does NOT (but I think...

That's what I'm looking for. Any idea of when the "future" is - Are we talking about version 8? -R.

I'm relatively new to PSD, but so far, I really like it. I'm having some issue with the Compare User Objects feature where triggers are concerned. If a trigger in the source schema is dropped, isn't detecting that and so it's not generating the appropriate DROP command for the target. This...