Database Link with 30 Character Limit on Columns
437788Aug 15 2008 — edited Aug 15 2008I would like to know if there is a way of having a Database Link from a SQL Server source, into Oracle, where I can have more than 30 characters in a column? (An unsupported name length)
If not, what is the workaround as to avoid errors? I don't want to migrate data, just to use a database link to the data in SQL Server. Bear in mind, that I am constrained in that I cannot change the SQL Server source in any way.
Thank you for your kind comments.