I had the same issue. I created a view which pulled data from an Oracle DB via a linked server. My view worked fine.

When I referenced the view in another database, I got the error: The OLE DB provider "OraOLEDB.Oracle" for linked server ... supplied inconsistent metadata for a column.

I came to find that my compatibility level for the database containing the view was set to 100 - SQL Server 2008, but the database with a query referencing the view was set to 80 - SQL Sever 2000. When I changed my compatibility level to 100, I stopped receiving the error.

Hope this helps.

Mitch Owen