Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-06-18 : 11:19:09
|
| Hi,I created linked server to Oracle. There is a mytable that is exported from SQL S to Oracle via DTC.Everything seems to be fine, with one exception: queries (from SQL Analyzer) to this Oracle table are not possible, the error is:Server: Msg 7356, Level 16, State 1, Line 1OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time.Other tables are accessible. As per:MS Knowledge Base Article – 251238 Table is created specifying Nullability !Mytable is created in SQL S as SELECT * INTO mytable FROM oldtableOld table has a computed column called “UTC”.Mytable has not a computed colunm – UTC is a fixed column there (sp_help)Any suggestions about the way to query mytable in Oracle are highly appreciated!Thx,Dobby |
|
|
|
|
|
Linked table in Oracle