tag:blogger.com,1999:blog-5215551487816981140.post5805738098286057610..comments2024-03-28T22:27:48.595-07:00Comments on ORA-00001: Unique constraint violated: Longer names coming to Oracle?Morten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5215551487816981140.post-18312313415895197362016-08-10T06:46:38.104-07:002016-08-10T06:46:38.104-07:00@Morten: I know your post is from a year ago, but ...@Morten: I know your post is from a year ago, but just today I ran into the following page on OTN.<br /><br />https://community.oracle.com/ideas/3338<br /><br />This poll was recently closed. Maybe your optimism will be rewarded after all. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-56646970621119508422015-07-08T03:50:34.861-07:002015-07-08T03:50:34.861-07:00@Jeffrey: Thanks for the links, maybe you are righ...@Jeffrey: Thanks for the links, maybe you are right. I remain cautiously optimistic that this might also apply to table, column, parameter and variable names in a future version... :-)<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-36097023541945801092015-07-07T20:54:49.312-07:002015-07-07T20:54:49.312-07:00I'm not so optimistic, although it would be gr...I'm not so optimistic, although it would be great to see this restriction lifted.<br /><br />I believe the increased size limit in the data dictionary is due to the need to support long database link names and long VPD identifiers:<br /><br />https://docs.oracle.com/database/121/SQLRF/sql_elements008.htm#SQLRF51129<br /><br />http://docs.oracle.com/database/121/DBSEG/release_changes.htm#BABJIGDEJeffrey Kemphttps://www.blogger.com/profile/04255101699328756710noreply@blogger.com