mysql table problem

[Arsalan]

Hello sir.
I made dblink between mysql and oracle 11g the connection is working well, but
I have one table in mysql have 16 columns when I select all columns remotely from oracle like this

(select * from "_1396"@mysqltes)

It show me 15 columns ,actually it have 16 columns
I check table name and columns name that is correctly exist in mysql but not show in oracle 11g remotely.

Kindly guide me.

Arsala khan

[ErmanArslansOracleBlog]

Hi,

What is that 16th column? What is its type?
It it is nchar, nvarchar type, then you may check - > http://www.dba-oracle.com/t_ora_00904_select_nvarchar_sql_server.htm

If it is not related with this, then update me accordinly. Send me all the info you can. (oracle version, sqlserver version, table-column specifications(all columns of the table and their types), the method you followed when building the Oracle-SQLSERVER Db link....)

[Arsalan]

Thanks a lot  Arsalan for replay


The problem have been solved by increasing  size of column which was not show remotely

varchar (255) I increase to Varchar (1000) ,

now i can see all columns remotely

[ErmanArslansOracleBlog]

Good.
Thanks for the info.