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

premmehrotra_at_hotmail.com wrote:

> 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

Rename the columns.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)