please excuse my english… anyway i will try to describe my problem/question:
Does there exist a kind of Macros or a possibility to automize work with models in Toad DM?
For example: We use Domain-based Datatypes in very many attributes in very many tables. To change the Datatype for those attributes by changing the domain is no problem; i just have to modify the domain (datatype, default-value etc.) in a single step; so far no automation neccessary.
My problem is as follows: I don’t just have to modify an existing domain, but i have to change the assignment between a domain and more than hunded attributes which use that domain to another domain.
How can i do that quickly? Manually i could open several tables and hundreds of attributes an change the assignment e.g. from “MyDomain” to “MyNewDomain”. Is there a way to use a kind of “Macro” for that?
As a “workaround” i changed the technical “id” in the .txp-File to the “id” of “MyNewDomain”. That worked when i re-opened the model.
Any better recommendation? Please note that in my special case i can’t just modify the existing domain but i have to change the assignment.
Beside the described problem a kind of automation could be useful for several other constellations too.
I hope you can relate to my problem. Thank you very much for giving me a hint!