Recent content by Jared Cooper

Hi Bernhard, I agree, I would not expect PL/SQL Developer to be able to produce valid output if the source table is partitioned but not the destination (or vice versa). However, in our case both source and destination tables are partitioned, it's just that the number of partitions is different...

Great, thank you for considering this request. Regards, Jared

When using "Compare User Objects", a few "Ignore..." options are available to ignore insignificant differences. Please consider adding 'Ignore partition differences'. When comparing schemas from a development database to a live database, many, if not all, the partitioned tables are listed as...

Thanks very much, I'm off to make a copy of all the SQL's now, just in case I strike again.

I've managed to screw up the cursor tab by accidentally deleting the SQL in the config window. Can anyone tell me what this should be please? TIA

Thanks for replying. I figured out the problem a few minutes ago, but got collared by a user to sort out an app problem (always the case when I;m in the middle of something). I was getting the error when connected as the SYS user, but as the user owning the triggers the properties displayed...

Downloaded Developer today for evaluation, so far impressed (very much so, in fact) but I cannot view any triggers. Any atttemp to select a trigger, I get error 'Properties of xxx.trigger not avaiable'. Server is v9.0.1, client workstation has personal server 9.2 installed. Any thoughts?