I ran into similar problem using ASE OLE DB Provider (Sybase). I was using a data source and had quoted identifiers enabled so Provider was sending incorrect syntax for the call to collect table information. Turned off the quoted identifiers and now it works. Does Oracle data source have a similar setting?