does DS support private synonyms from different schemas
Posted: Fri Nov 04, 2005 9:25 pm
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...
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...