|Subject:||Exporting a table from Microsoft Access to Oracle gives error ORA 972|
|Date:||30 Dec 2004|
I am using Microsoft Access 2000 and Oracle 18.104.22.168 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
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
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,