DSXchange

Hi,
I am trying to import metadata frm schema but am not able to see the synonyms created in the schema from the other schema..

say for example i have 2 schemas a,b
i have created a public synonym in 'a' for a table of 'b'..tried to import the same table def from 'a'(which i have access to in DS)...how ever i donot find the table or synonym created in the schema 'a'.how should i import the metadata frm a public or private synonym created..does DS support importing tables(synonyms created on diffetrent schemas)...

i am able to see views but that does not help me in dynamic environment as i donot have access to schema 'b' which is wholly used for a secured functionality that cannot be discussed across teh business...

pavanns wrote:Hi,
I am trying to import metadata frm schema but am not able to see the synonyms created in the schema from the other schema..

say for example i have 2 schemas a,b
i have created a public synonym in 'a' for a table of 'b'..tried to import the same table def from 'a'(which i have access to in DS)...how ever i donot find the table or synonym created in the schema 'a'.how should i import the metadata frm a public or private synonym created..does DS support importing tables(synonyms created on diffetrent schemas)...

i am able to see views but that does not help me in dynamic environment as i donot have access to schema 'b' which is wholly used for a secured functionality that cannot be discussed across teh business...

Are you checking the include synonyms option when you try to import? It does provide you to get the metadata of the synonyms and from systables (include systables option DS7.x) as well.

No synonyms.

For example, Oracle OCI plugin metadata import prompts you for ALL OWNERS or a specific schema. It's just selecting from ALL_TABLES to get the tables to import, so therefore, you need to know the schema of interest rather than the synonym.

How can you create a synonym to a table you can't access? Therefore, just change the owner to reflect that schema and you should see the tables.