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

Giganews Newsgroups
Subject: Exporting a table from Microsoft Access to Oracle gives error ORA 972
Posted by:  premmehrot…@hotmail.com
Date: 30 Dec 2004

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

Replies