Compare schema enanchement

[Daniele Bizzarri]

Hi, I'm using your product very wisely and I find it the best one in all Oracle Tools available on the market.

I want to suggest you an enhancement. When comparing schemas, the sql that align the target schema (for drop) should be build by sorrounding object name with " character.

I report this case because of presence of recycle bin in 10g version.
This because when user drop an object and then restore it from recycle bin, oracle put some objects like constrains, foreign keys, ecc... with a name like BIN$J8hhXcEKnuDgQJOhoMgK8A==$0
That name is not usable (and so the object cannot be dropped) without sorrounding it with " character ("BIN$J8hhXcEKnuDgQJOhoMgK8A==$0").

I suggest you to do that.
Thanks
Daniele

 

[Marco Kalter]

The objects from the recycle bin should not appear in the selection list. Can you let me know your PL/SQL Developer version?

 

[Daniele Bizzarri]

My version is 7.0.31123

 

[Marco Kalter]

Hmm, we'll look into this.