Exporting a table from Microsoft Access to Oracle gives error ORA 972

I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000. When I export a table from Access to Oracle using ODBC I get error:
ORA 972 identifier too long

I think the error is because one or more columns in Access table are longer than 30 characters. My question is how one can overcome this problem.

I also see several column names which have /, ? or spaces in name but I think Oracle somehow takes care of that by putting names inside quoted string? I am just guessing, I am new to Access to Oracle mapping.

Any help will be greatly appreciated? Is there anyway I can create a table in oracle with 30 characters max long name and then map them to Access long names somehow?

Thanks a lot,

Prem Received on Thu Dec 30 2004 - 20:51:18 CST