Home » RDBMS Server » Server Administration » ora-00972 (identifier too long) vs. design (10g)
ora-00972 (identifier too long) vs. design [message #409093] Fri, 19 June 2009 06:02 Go to next message
mdoh
Messages: 2
Registered: June 2009
Junior Member
Hello,

I'm pretty new to Oracle and I'm in the process of porting a DB schema from Postgres to Oracle 10g. I hit the famous ora-00972 now.

Our Postgres DB reflects the names of our application's data models but these names break the 30 char limit of Oracle. The names often are combined names with prefixes separated by an underscore, e.g. "mymodule_specialperson_bankaccount".

If I now enforce abbreviations of the names to meet Oracle's needs I totally give up this nice structure. We've got a couple of tables (around 100 altogether) where we were able to group them logically by this naming scheme.

Could anybody advice me if there is an "Oracle way" to divide/design these things?

Kind regards
mdo

[Updated on: Fri, 19 June 2009 06:13]

Report message to a moderator

Re: ora-00972 (identifier too long) vs. design [message #409105 is a reply to message #409093] Fri, 19 June 2009 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No there is not.

Regards
Michel
Re: ora-00972 (identifier too long) vs. design [message #409117 is a reply to message #409093] Fri, 19 June 2009 08:28 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I've personally never seen the point of including system or table identifiers in a column name.
A column is a part of a table - that's all. The column name should describe the data that the column holds in the context of that table.
Re: ora-00972 (identifier too long) vs. design [message #409126 is a reply to message #409117] Fri, 19 June 2009 09:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is a pretty good article on the subject at:
http://www.gplivna.eu/papers/naming_conventions.htm

Regards
Michel
Re: ora-00972 (identifier too long) vs. design [message #409128 is a reply to message #409093] Fri, 19 June 2009 09:25 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Could anybody advice me if there is an "Oracle way" to divide/design these things?
Some/many/most folks think that if a column exists in more than 1 table, then column name should be the same; regardless of which table contains it.
Re: ora-00972 (identifier too long) vs. design [message #409142 is a reply to message #409117] Fri, 19 June 2009 11:38 Go to previous messageGo to next message
mdoh
Messages: 2
Registered: June 2009
Junior Member
Oh, sorry, that wasn't that clear before: I didn't talk about row but table names. We name the tables corresponding to our data models.

Re: ora-00972 (identifier too long) vs. design [message #409165 is a reply to message #409142] Fri, 19 June 2009 15:27 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, the answer doesn't change much - length is limited to 30 characters and that's it. Unfortunately, it means that you'll have a lot to do while translating table (and perhaps column) names to fit Oracle's naming conventions.
Previous Topic: Help on SQL Server 2000 to Oracle 10g
Next Topic: error in installing Workflow
Goto Forum:
  


Current Time: Sat Dec 10 02:51:22 CST 2016

Total time taken to generate the page: 0.18181 seconds