Synonyms in Oracle 10g RAC don't show any columns

promlow Feb 17, 2009 1:06 PM

I followed the instructions at https://www.jboss.org/community/docs/DOC-13271 and installed the Oracle 10 jdbc driver. I am able to map tables just fine, but all the synonyms show as empty with the error "The Base Table must reference 1 or more columns; there are none".

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.
Actions
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?
Actions

Go to original post