RE public synonyms

Toad Data Modeler
1

Hi,

This could be an enhancement request as well as a “How do I…”

I would like to be able to RE the PUBLIC synonyms for the objects (tables, packages, etc) that belong to the schema I am REing.

These are accessed by SELECT * FROM ALL_SYNONYMS WHERE OWNER=‘theowner’ OR TABLE_OWNER=‘theowner’;

As far as I can see I only get these if I deselect “Load Proc …Only from Users…of Selected Tables”. If I uncheck this I get loads of other items for the other schemas that I do not want.

I tried altering the SQL query in PreloadSynonyms() and LoadSynonyms() but I now get a failure in CorrectSelection().
I’m stuck now … can you give me some ideas?

May be for an enhancement you could extend the OTP for synonyms to have a “Load Public” extended value or sub item.

Thanks
Malcolm

2

Hello Malcolm,

I would like to be able to RE the PUBLIC synonyms for the objects (tables, packages, etc) that belong to the schema I am REing.

We will try to find the most acceptable solution. CR # 47 771.

I tried altering the SQL query in PreloadSynonyms() and LoadSynonyms() but I now get a failure in CorrectSelection(). I'm stuck now ... can you give me some ideas?

Could you please send us your modifications? It would help us to find why there's the problem. Thanks very much in advance.
(You can send it to: modeling@quest.com)

We look forward to hearing from you.

Regards,

Vladka + TDM Team

3

Hi,

Just a quick update:

CR 47 771 - will be resolved in v. 3.2.

Concerning the modification, please check out your email box. Thanks.

Have a nice day.

Vladka

4

Hi Vladka,

That seems to work fine thanks.

Malcolm

5

Great! Thanks for letting us know.

In case of any problems, please write us.

Regards,

Vladka + Mario