Wasn't sure exactly where to put this one...
We populate an Oracle data warehouse each night, and we connect to it via Linked Server connection. It works perfectly well for the most part.
One weird thing though... when I want to look at the structure of a table on the Oracle side, I go to the table via the Management Studio -- so basically Linked Servers --> <Server Name> --> Catalogs --> Default --> Tables --> then right-click on the table name and choose "Script table as SELECT FROM..." it returns the table column, but it repeats them. The primary key column is repeated twice, and the other columns are repeated six times each.
The query it creates is "right" insofar as it includes all of the columns and in the right order - it's just duplicating them.
I am not sure if this is a SSMS issue, or an Oracle issue.