By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
I created a database link from Oracle 10g to MS SQL Server. It works. I can select from tables on SQL Server. In one table there is a column name larger than 30 characters. I don't select this column but I get this error: "ORA-28500: Attempt to access a column Address_OutputMedium_Caption_ID with unsupported name length (greater than 30 characters)." I can't change the name of this column. What can I do? Thank you very much for your help.
You cannot force Oracle to query any table that has a column name longer than 30 characters, even if that table is stored in a database system that allows longer column names, like SQL Server. About the best you can do is to create a view in SQL Server that queries the table. This view would change the column name.
CREATE VIEW my_table_view (column1,column2,
AS SELECT column1,column2,column3_is_much_much_much
In Oracle, you query the view, which pulls data from the table.