This content has been marked as final.
Show 2 replies
-
1. Re: Synonyms in Oracle 10g RAC don't show any columns
blafond Feb 19, 2009 9:09 AM (in response to promlow)It's my understanding that Oracle Synonyms are just pointers? So Designer importer recognizes that it's of type "Base Table" but does not follow the reference to the actual table to retrieve column data. The error you get is a validation error. Tables must have at lease 1 column to be valid.
-
2. Re: Synonyms in Oracle 10g RAC don't show any columns
luca_gioppo Mar 24, 2009 9:57 AM (in response to promlow)Is there any way of making Teiid following the sysnonyms?
Tools like SquirrelSQL does follow them and sometimes access right allow just that privilege?