Toad World® Forums

Identifier too long..


#1

Happy Friday everyone

I am creating an Oracle DB for my Objects Processor program some of the names of
my columns are

FederalAcronym1_FederalAcronmyn2_FederalAcronym3_ALongerFederalAcronym_AReallyLon
gFederalAcronym_ColumnName

the DB engine complains with a ORA-00972
this is for a federal client who want to keep ALL of the acronyms in the table
and column names?

Can anyone suggest a workaround to allow my client to keep the >64 character
long column names?

Thanks!
Martin Gainty


please do not modify/disrupt this transmission. Thank You


#2

Well, if the desired outcome is reporting, you could set up a metadata table to
store the actual name you want on your report and use generic names for the
actual columns. Naturally, your reporting program must allow you to substitute
the names after the data is read from the table:

Create table fed

(column1,

column2,

column3,

etc.)

Create table col_xref

(table_name,

Col_name,

Col_label)

In table col_xref:

Fed,column1,

FederalAcronym1_FederalAcronmyn2_FederalAcronym3_ALongerFederalAcronym_AReallyLongFederalAcronym_ColumnName

Fed,column2, TheLongestFederalAcronymInExistence

Fed,column3, InTheGuinessBookAcronym

Best regards,
Mike

Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,
Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The World
Depends on Sensors and Controls


#3

Oracle only allows 30 character column names. I don’t think there is any
working around it.


#4

It might be easier to use column comments for this rather than a whole other
table J


#5

Yeah, but that’s no fun.

Best regards,
Mike

Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,
Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The World
Depends on Sensors and Controls


#6

i wound up doing this

CREATE TABLE FS1(
COL1 VARCHAR2(80);
)

CREATE PUBLIC FederalSynonym1 for FS1;

SELECT * from FederalSynonym1;

so the select on FederalSynonym1 still works…but i would very much like to keep
the ACRONYMNS as their ‘full descriptive name’

Thanks Bert and Mike!

Martin Gainty


please do not modify or disrupt this transmission. Thank You